Trying to Copy a record from a form that is based on two tables. I need to copy everything to the new record except the auto (key) number. My Entry table which issues an auto number[id] and the other table stores this number in [id_numb] as an intreger. What is the best way to do this?
Follow Up
I am only copying a record if the person needs to update it, without changing the original record. The code allows the original record to get a tag and a modify date while the new copied record also gets a tag and the original date is indicated.
The first table is an event table with a time date stamp. which is refered to by all other tables.
Below is the basic idea. Again thanks
Select record on Form 1
Click Modify Command
Test if Rec can be Modified
If No exit
If yes
Copy record (issue new auto number)ID
Modify = True
Modifydate = original modify date
Open assocciated Form 2
Goto This new record.
[This message has been edited by Dwaynair (edited 01-19-2000).]
Follow Up
I am only copying a record if the person needs to update it, without changing the original record. The code allows the original record to get a tag and a modify date while the new copied record also gets a tag and the original date is indicated.
The first table is an event table with a time date stamp. which is refered to by all other tables.
Below is the basic idea. Again thanks
Select record on Form 1
Click Modify Command
Test if Rec can be Modified
If No exit
If yes
Copy record (issue new auto number)ID
Modify = True
Modifydate = original modify date
Open assocciated Form 2
Goto This new record.
[This message has been edited by Dwaynair (edited 01-19-2000).]