I have a new record entry form in my Access 2007 DB which has a datasheet view subform in it. When the form is opened, the primary key (autonumbered) says "(New)" until a field in the form is edited, at which point the primary key is populated with the next auto-number.
However, if i proceed directly to the datasheet view subform and add items, the primary key is never generated, which, if the user closes the form at this point, breaks a query for a report (no primary key for the main records)
How can i programatically tell the form to generate the autonumber? I've tried running the acCmdSaveRecord command on various event and even when the event fires this does not solve my problem.
Thanks in advance!
Joe
However, if i proceed directly to the datasheet view subform and add items, the primary key is never generated, which, if the user closes the form at this point, breaks a query for a report (no primary key for the main records)
How can i programatically tell the form to generate the autonumber? I've tried running the acCmdSaveRecord command on various event and even when the event fires this does not solve my problem.
Thanks in advance!
Joe