Thanks Agin... Joe
--- In [email protected], "Crosier, Dawn" <[EMAIL PROTECTED]> wrote: > > 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/
