open form new record

[accesshelpme]

I have a form that opens and when it opens it automatically goes to a new record, rather that showing the first record. 2 of the text boxes on this form have enabled set to no and are automatically filled when the form loads. However, this means if someone goes to this form and then exits out immediately, a record is saved that only has the information that was automatically filled when the form opened.


I want to have it so it doesn't save unless someone clicks the save button, rather than automatically, is this possible

thanks

[Bob Fitz]

I have a form that opens and when it opens it automatically goes to a new record, rather that showing the first record. 2 of the text boxes on this form have enabled set to no and are automatically filled when the form loads. However, this means if someone goes to this form and then exits out immediately, a record is saved that only has the information that was automatically filled when the form opened.
I want to have it so it doesn't save unless someone clicks the save button, rather than automatically, is this possible
thanks

IMO rather than trying to stop access from behaving as it was designed to do, it would be better to do some validation in the form's Before Update event of the data entered. If the validation fails, the data update can be cancelled.

[accesshelpme]

can you giev me and exmaple of what u mean by that?

[Bob Fitz]

Take a look at the attached db