Thanks Tobi!
--- In [email protected], "Hoffman, Tobi K \(DYS\)" <[EMAIL PROTECTED]> wrote: > > 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 > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/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/
