Copy a record

[jen]

Hi There -
I have a database set up with purchase orders. I have
two tables which are pretty standard tbl_orders and
tbl_orderdetails.

I want to make a button that will copy the information in
the current open form & subform and create a new order
with a new PO #. What is the easiest way to do this?

Please help!
Thank you.

 

[Steve Schapel]

Jen,

The easiest way to do this is to make an Append Query to add a new Order
to your tbl_orders table, and then use an OpenQuery macro on the command
button's Click event to run the append query.