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/
 



Reply via email to