Sir, I don't know what your name is but I have a similar problem, creating a table when the user enters data on a form. The solution I may try is to read a table I need and build an array when the form is opened. Then when the user enters the requested salesperson on the form code can search the array for the necessary fields needed for that particular salesperson.
hope this helps Mando....... --- In [email protected], "jamrmask" <[EMAIL PROTECTED]> wrote: > 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/
