Saving records

[vols77]

On the form, there is a button "add record" that when clicked, the new record automatically fills in the field "Job", what I am tring to do is to prevent the user from saving the record unless the field "BOL" is filled in.
I have tried several things but can not seem to figure it out.

Ideally,
If the user tries to exit the form without the field being completed a pop up box saying "BOL" not entered, if you exit, the record will not save. Do you wish to exit? Yes or No.
If the user chooses "YES" then the record will not save and the form will close, or if they pick "NO", the focus will go to the record to allow them to enter a value in the BOL field.

One thing someone told me is that I should make sure the code goes for both null and as if the user entered then backspaced the value out of the field.

Any suggestions are greatly appreciated!

 

[ZOR]

Have a look at TheAceman1's code at the bottom of this page, you can use it for as many controls wanted. Hope it helps

http://www.tek-tips.com/viewthread.cfm?qid=1364022

 

[vols77]

I am lost in the translation from the posted code to what I would need to change to work....

 

[PHV]

A common way is to enforce the validation rules in the BeforeUodate event procedure of the form, playing with the Cancel argument and the SetFocus method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886