Waiting for confirmation to write a record.

[7Oclock]

I would like to delay writing to the database until after a confirmation button is clicked on in the data entry form. Because if the data entry form is simply opened then a record is created and it is, in this situation, an empty record.

 

[PHV]

You may play with the BeforeUpdate event procedure of the form and its Cancel argument.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244