I have a field called OnTime on a form that has code to fiqure out if
a condition exist and then set the status code which works fine. My
problem is I have a report generating from the same query as the form
and when I preview or print the report the On Time status will not
show until I cycle through all of the records except for the very
first record. I have the code in the OnCurrent event, what is the best
way to update the status without cycling through all of the records on
the form?
If [DueShipTime] > [Dispatch Date Time] Then
[OnTime] = "On Time"
ElseIf IsNull([Sched Qty]) Then
[OnTime] = "Not Scheduled"
ElseIf IsNull([Dispatch Date Time]) Then
[OnTime] = ("No Dispatch Time")
Else: [OnTime] = "Late"
End If
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/
