Not Saving the Form

[sturner333]

I open a form for a "New Project" and populate the Project Number text box when the form opens. Can I make it that the form is only saved if I determine I want to have it save? Reason being if I populate the Project Number but the user does nothing else, I don't want the form saved to the table.
Thanks

 

[PHV]

Use the BeforeUpdate event procedure.

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

 

[sturner333]

What would you do in this procedure to keep it from saving?
Thanks

 

[PHV]

In the BeforeUpdate event procedure of the form you enforce all the validation rules setting Cancel = True if any fails.

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

 

[sturner333]

Thanks PHS!