If IsNull(Me.placement) Or Me.placement = "" Then
MsgBox "Must have start date"
Me.StartDate.SetFocus
Else
MsgBox "You have done it correctly!", , "Good Job"
End If
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of eliotchs
Sent: Friday, January 20, 2006 11:19 AM
To: [email protected]
Subject: [ms_access] ?? on checking null value w/ msg box
Hi,
I'm trying to put up a msgbox on form close if one field has a value but
another doesn't, I can't seem to work out the logic..
Example(I know the sytax is wrong, just what I looking to do)
If me.placement is not null AND me.startdate is null then Msgbox "Must
have start date"
setfocus.startdate
end if
Thanks In Advance
Joe
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
