This seems like a really easy one, but it's got me stuck!
I am using the "DoCmd.GoToRecord , , acNewRec" command on a command button to open a form with blank fields ready to create a new record.
However, I'm finding that when I close the form, the record is saved automatically!!
Can someone give me a way of forcing the user to decide whether to save the record or not when leaving the form.
If they select no, the form closes without saving the record and opens the main form.
If they do select save, ideally another msg box should ask if they want to create another record.
If yes, the form fileds are reset in preparation for a new record to be entered.
If no, then the form closes without saving the record and opens the main form.
Cheers for your help!