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


Form A
controlname: WorkItem

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
jbroc