Adding new record from datasheet view in split form

[Fish218]

Folks,

I am trying to create a data entry form from one table tblCommCatch. I am using the "split form" design. I have fields in the header that are combo boxes that the user will select once and then in the datasheet view add additional data. I don't want the user to have to go back to the combo boxes in the header to add a new record. I already set default values for the combo boxes in the header. When I tab to a new record in the datasheet, the PK (CommCatchID) in the header does not advance. How do I get this to work?

[June7]

Do you still need assistance or is this issue superseded by other thread https://www.accessforums.net/showthr...t-record-entry

[Fish218]

I realized I can't use split forms as a subform. Sorry. I did figure out how to get this to work using after update event procs though. Thanks!