Saving

[Lyndseyd]

Hi all,
when the users are saving the form, i want to make sure they have filled in certain fields. On previous forms my code has worked, but for some reason on this form it won't, i usually put:


If tankID = "" Then
MsgBox ("Please Enter the Tank ID")
tankID.SetFocus
End If

Can anyone explain why it may not be working, thank you

 

[Laoujin]

If you enter this code in the BeforeUpdate event you will need to do something like:

If IsNull(Me!tankID) Then
MsgBox("Error!")
Cancel = True ' This makes sure the form is not saved.
Me!tankID.SetFocus
End If

 

[Lyndseyd]

thats great, thank you for your help

 

[ghudson]

Use the forms BeforeUpdate event for all data validation.

Check these links out for some working examples that will assist your project.

A Better Mouse Trap?

Enable/Disable The Control Box X Button

Searching the forum is a great way to discover and learn the answers to your Access programming questions.