My goal is to have the form, when opened, to open to a new record.
Private Sub Form_Load()
DoCmd.OpenForm "Inventory Details", , , , acFormAdd
End Sub
This is my code in the Form On Load event. I'm sure I am doing something stupid but I can't figure it out. Thanks again.