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

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

DoCmd.RunCommand acCmdSaveRecord

Thanks, worked.