Retrieve Autonumber field and update it

[carrie09]

Hi,

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?

Eg.

Table1
Fields - F1, F2 and F3
Autonumber - F1
Insert updates F1 and F2

How do I update F3 for F1 that was created?

 

[TheAceMan1]

How are ya carrie09 . . .

According to you these checkboxes are unbound! . . . [blue]Why are they not bound?[/blue] . . . or fields of the table?

See Ya! . . . . . .

Be sure to see thread181-473997

 

[carrie09]

Hey..Am good..thanks..
How abt u?

The reason they are not bound is becaus the form has values from a lot of other tables and inserts values in different tables.
So I just left these unbound so that I can get values and update the table.
Does that sound correct?