I need help with copying specific records from one subform to another. Basically the user highlights the whole record with cursor presses a button and that record appears on the subform below. The data in the second subform will be static (to produce a report from) but the data in the first subform is generated from a query using text boxes.

Any Ideas?
Mark

If your data comes from a query and will not change by the time you need to call it up again, there is no point in storing it twice. This violates database normalization rules (gods I sound like a guru today).

If your underlying data can change and you need a record of your data at this moment in time, then there are ways to store it.

Post back with more information,
David R

Basically I have a table storing all product data, I have 2 text boxes on a form and 2 subforms, the data entered in the text boxes form a query that displays data from the main table in the first subform. I then need the user to select the record from the first subform, click the button and append the data to the second subform (and table) for reporting purposes. I hope you can understand my ramberlings! I think I know what I mean??? :-)

Yours in anticipation!
Mark.