Retrieve Autonumber field and update it
I have a subform that has a table as record source. I'm including this subform on another form.
Now when user enters values in the subform, it inserts those values in the table and this table has a autonumber field so every insert generates a new autonumber.
In my form I have some more fields from check box that i have to relate to the autonumber generated from subform.
My question is how do I access the autonumber I generated and update some values on that particular autonumber related fields?
Fields - F1, F2 and F3
Autonumber - F1
Insert updates F1 and F2
How do I update F3 for F1 that was created?