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/