I am not sure this is the problem, but your code sets the focus on the the Starttime field twice. Look at bold below.
TJ
brazilianbound <[EMAIL PROTECTED]> wrote:
TJ
brazilianbound <[EMAIL PROTECTED]> wrote:
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! Personals
Let fate take it's course directly to your email.
See who's waiting for you Yahoo! Personals
Yahoo! Personals
Single? There's someone we'd like you to meet.
Lots of someones, actually. Yahoo! Personals
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
