Use two subforms to enter data into table

[CFP - Russell]

I have 2 subforms that I want to use to enter data into one table. I have a table with about 16 fields so I wanted to be able to enter the first 8 in one subform form then the next 8 in another. The problem I am running into is that when I enter data into the second subform it does not add to the correct record, it adds it to the next one. If I close the form and then re-open it everything is fine.

Does anyone know how to make it so that when a new record in the datasheet is added to the first subform, the row is also added in the second subform.

I believe that this can be accomplished using a requery command of some sort because it works once I close the form and reopen it.

Thanks,
Russell

 

[Mile-O]

Double Post