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?

Use a combo box on the main form and requery it when it gets focus.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

I don't understand the question.

If a user updates fields in the subform and enters data for F2, why would that person also NOT enter data for F3 at that time manually as he/she did with F2?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

The reason being that the fields in subform are like datasheet and can be entered multiple times however the checkbox can be entered just once and will apply automatically to all fields in subform.

If I use the update statement for check box in my code then user will not have to enter this for all the line items he enters in the subform.