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
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
