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 think I just want to get to form2 taking the data from
form1 and then execute some SQL using DoCmd but what do
you suggest?
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 think I just want to get to form2 taking the data from
form1 and then execute some SQL using DoCmd but what do
you suggest?
I assume I need to hold on to the original record so that
nobody else grabs it in the meantime.