Verifying data before entry
- From: Newbie <Newbie@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 20 Jun 2005 14:07:02 -0700
I have a 'Verify' button on a form. When I click the button, I want it to
check if the value of a yes/no field is true and the value of a date field is
null, then to show a message box saying that the user forgot to enter a date.
I can't seem to get it to work. Please help. Here's what I'm trying to
type:
If dc.value = true and dcpostdate.value = null then Msgbox "You forgot the
posted date"
End If
It shows the value of dcpostdate is null but the code does not return the
message box. I have tried setting the default value to null and it doesn't
work.
.
- Follow-Ups:
- Re: Verifying data before entry
- From: RuralGuy
- RE: Verifying data before entry
- From: Ofer
- Re: Verifying data before entry
- Prev by Date: Make Code to Set Default On Open
- Next by Date: Re: Validation Rule for field
- Previous by thread: Make Code to Set Default On Open
- Next by thread: RE: Verifying data before entry
- Index(es):