Data Entry in Form

[johanhjalmarsso]

I don't want the form to add the record if I put in a value in a field. I want it to add the record when I press a "Add information to a record"-command button. How can I do this?

My form is in data entry mode.

 

[Mile-O]

I don't want the form to add the record if I put in a value in a field. I want it to add the record when I press a "Add information to a record"-command button.

But, once you enter information into a field then that space is reserved for that record and it is subsequently created. If you don't want to save the information if the 'Add' button is not clicked then you can use the Form's BeforeUpdate event to Cancel the record and Undo everything.

 

[RuralGuy]

You could also do an unbound form and do all of the work yourself in VBA. It seems like a lot of effort but there are times when it is the best approach. As with SJ McAbney I prefer letting Access do what it does best and use the undo features plus make a delete as easy as possible as long as it will not compromise the integrety of the data.