B
Brian C
Struggling!
I have a form where I select a specific record from Table
1 and check a field. If it is a certain value then I want
to link to another form and get the user to enter details
that create a record on Table 2. I then want to take the
key field (an Autonumber) of this record written to Table
2 and overwrite the field I checked on Table 1!
How do I do this? What code do I need and where do I put
it?
I assume I need to hold on to the original record so that
nobody else grabs it in the meantime.
I have a form where I select a specific record from Table
1 and check a field. If it is a certain value then I want
to link to another form and get the user to enter details
that create a record on Table 2. I then want to take the
key field (an Autonumber) of this record written to Table
2 and overwrite the field I checked on Table 1!
How do I do this? What code do I need and where do I put
it?
I assume I need to hold on to the original record so that
nobody else grabs it in the meantime.