copy and paste
NewBe, starting to use vba.
I have a sub that in a form control that opens a table using the Select Case.
When the table opens, I then select the record that I want and close the table bringing me back to the form view. the sub code then paste the data into the control, however, it also pastes the table field names. ie.....
Table A Data
IDNO : 1000
WorkItem : Fix Pipe
When I paste into the control text box, below is whats pasted.
Anyway I can eliminate the Table Field names being pasted.
IDNOWorkItem ...1st line
1000FixPipe.........on 2nd line
Thanx for any input to my glitch
Last edited by jbroc; April 21st, 2011 at 09:59 AM.
Reason: to make more understanding