Copy records...

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.
 
R

Rick

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
 
J

jacob

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?
 
Top