Copy records...

  • Thread starter Thread starter jacob
  • Start date Start date
J

jacob

How can I copy records from one table to another based on a check box?
What I am trying to accomplish is that when open my form to a record, and I
put a check mark in a check box, I want this record information to copy over
to another table where I can run a report based on that one record.
 
Why would you copy them to another table? Why duplicate information? Why
not just have your report only select records with a checkmark, then
(onclose of report) change all the chackmarks to unchecked again?

Rick
 
I thought of that but I need to generate another AUTONUMBER so that we can
use this as a confirmation the item was returned. Am I going about this the
wrong way? Or can I generate yet another unique number based on that report?
 
Back
Top