update first field in current record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 tables.
Table 1 - main table,
Table 2 - subform table and the one that gets cleared prior to next update
Table 3 - table that permanently stores data from table 2 and is linked to
table 1 using the primary key autonumber.

In the coding of my form once a button called submit is clicked then
1st - information entered onto the form is udpated into Table 1.
2nd - information in subform updated into Table 2
3rd - query is run to copy the data from Table 2 into Table 3 and also copy
the Autonumber (primary key) from Table 1 into Table 3 next to the
inforatmion that has just been copied from Table 2
4th - Table 2's contents is cleared

Problem
Cannot copy just the new Autonumber for current record being updated from
Table 1 into Table 3 but only next to the data being copied from Table 2.

Hope the above makes sense.
 
Table 2 is being used to copy the data into Table 3 and is then being
cleared? Why?

Whatever it is your trying to do, there's a better way of doing it than
that. You'd be best off just reposting with the actual thing you're trying
to do (probably best to start a new thread rather than just rely on this one
to come up with the best idea)
 
Hi Rob
Thank you so much for your advise, I have tried putting all the keycoding
into the submit button and know all the feilds update.

Thank you again
Noemi
 
Back
Top