Thanks Tobi. I didn't know that one. Neil Squires
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Hoffman, Tobi K (DYS) Sent: Wednesday, December 07, 2005 6:53 AM To: [email protected] Subject: RE: [AccessDevelopers] If Statement Help! The colon can be used to separate multiple statements on a line, so that would not cause a problem in itself. Without the colon, you would go to a separate line for the part that comes after. Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Squires, Neil Sent: Tuesday, December 06, 2005 4:32 PM To: [email protected] Subject: RE: [AccessDevelopers] If Statement Help! Also, you should not have a ":" after the else keyword. Neil Squires -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Squires, Neil Sent: Tuesday, December 06, 2005 2:18 PM To: [email protected] Subject: RE: [AccessDevelopers] If Statement Help! If isnull(Forms![SCANFORM]!StartTime) Then Try that. Neil Squires -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of brazilianbound Sent: Tuesday, December 06, 2005 2:09 PM To: [email protected] 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 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 --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/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/
