How can I Copy and paste a record from one form to another ?

[lebanoncedars]

Hi there,
Can anyone knows how to copy one record from Form1 to Form2?
I have the same fields in both forms related to one table.

form1 = continous form. to see all records
form2 = regular form. to fill in customer informtion.

Details Please.
Thank you

 

[jitter]

Pass the primary key field of the selected record from the first form and use it in the filter property of the second form when you open it.

You can actually have access write the code for you by making sure that wizards are turned on and creating a new command button. Walk through the wizard telling it what you want to do and everything should be peachy.

Hope this helps....

 

[lebanoncedars]

hi jitter, Thanks.
I had accually an error when I pressed command button in form1 to paste the record in the second form2..
The error was paste append not presented here.

Something wasn't done right.
By the way, it doesn't have to be the same customer ID in the second form, I want that command button ( copy) to copy the record and paste it in the second form2 so I can reserve another booking for the same customer.

I hope its clearer now.

thank you again,

More details PLS.

Lebanoncedars