Default entry reqd

John thomas

Registered User.
Local time
Yesterday, 17:09
Joined
Sep 4, 2012
Messages
206
Hi
If i say yes to the default entry reqd .
And when not entering in a field I get the massage entry reqd ,but when clicking ok it repeats the message box and does not let me make an entry ,and eventually says access can not save this and needs to close .
Is there a better wy of doing this ,So that if afield is missed a message box pops up with an apropriate mesage and lets you then enter in the field
 
I would use some code in a form's Before Update event to validate the data.
Something like:
Code:
If Nz(yourControl,0) = 0 then
  Msgbox "your message", vbOkOnly, "Required information"
  Cancel = True
  Docmd.GotoControl "yourControl"
End If
 

Users who are viewing this thread

Back
Top Bottom