Save record while form is open (1 Viewer)

[geno]

HI,
I've searched the site and can't quite find anything to help me. I have a form to enter in customer informaton, then a button to open another form to enter in customer preferences. The second form has a where clause [customerID]=[Forms]![frmcustomer]![customerID]. This works good for all the records except the new entry. Is there a way to update the new record so when the user clicks to go to the second form that record will show? Thanks

 

[Pat Hartman]

In the click event of the button, before you open the second form, add the following:

DoCmd.RunCommand acCmdSaveRecord

 

[geno]

Thanks, worked.