Forms (1 Viewer)

[Dwaynair]

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).]

 

[elamberton]

Have you tried using a query to do that for you? Its much simpler than getting a form to do it.

 

[Pat Hartman]

I'm not sure why you would want to make a second copy of every record but I would put code in the Form's AfterUpdate event to append the row to the second table. Just refer to the form fields to pick up the values.

What if anything are you doing if a record is changed or deleted?