Copy a record

  • Thread starter Thread starter jen
  • Start date Start date
J

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. :)
 
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.
 
Back
Top