Also, you should not have a ":" after the else keyword. Neil Squires
-----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Squires, Neil Sent: Tuesday, December 06, 2005 2:18 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] If Statement Help! If isnull(Forms![SCANFORM]!StartTime) Then Try that. Neil Squires -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of brazilianbound Sent: Tuesday, December 06, 2005 2:09 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] If Statement Help! Hey all! Can someone tell me what is wrong with my IF statement - I know i'm close but it's making me nuts. Basically what i'm trying to do is that on After_Update, if Startime is empty, then put the time in and also the startdate. If it is not empty then populate the StopTime & StopDate. - Thanks! Private Sub Doneby_AfterUpdate() If Forms![SCANFORM]!StartTime Is Null Then Forms![SCANFORM]!StartTime.SetFocus Forms![SCANFORM]!StartDate.Text = CStr(Date) Forms![SCANFORM]!StartTime.SetFocus Forms![SCANFORM]!StartTime.Text = CStr(Time) Else: Forms![SCANFORM]!StartTime = Not Null Forms![SCANFORM]!StopDate.SetFocus Forms![SCANFORM]!StopDate.Text = CStr(Date) Forms![SCANFORM]!StopTime.SetFocus Forms![SCANFORM]!StopTime.Text = CStr(Time) End If End Sub Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
