I have a form in access that contains two subforms the reference two separate tables. when i type in and eventID the form pops up with the text box and data in each subform corresponding to the EventID. Now i want to have the data in the two subforms to dump into the text box that is on from a different table than the forms. I was hoping to just hit a command button and have these buttons dump the raw text into the box. It is sort of like copying and pasting the information in from the two subforms into the text box without highlighting each individual time etc. etc. and pasting each time. I want it to do it in one fowl swoop. PLEASE HELP.!!