Stop Form Adding Records to Table

[karl05]

Hi,

I have a form in Add mode that keeps entering records in my table whenever something is typed in any field. I would like to stop the automatic creation of the record until all fields are completed or when a Save button is pressed.

Any ideas?

 

[neileg]

You could use an unbound form and append the data using code on a button. Or you could bind your form to a temporary table and append the data using an append query on a button.

 

[karl05]

Thanks

Thanks,

I hadn't thought of it that way. I was looking for a property or something to change but will try that, it make sense.

Cheers
Karl