S
Steve
I have a table that keeps track of items being issued and received to a
satellite facility. It contains 4 fields:
Issue_ID - Auto Number
Date_Issued - Date Field
Saw_ID - Item Serial Number - Text
Date_Returned - Date Field
What I am trying to do -
I have one form that has a list box that lets the user choose which Saw_ID
they would like to issue and once they choose them and click the issue box it
creates new records containing an Issue_ID, the appropriate Saw_ID and todays
date for the Date_Issued field.
I have a second form with a list box that contains the Saw_ID's that have
been issued but the underlying info is bound by the Issue_ID and once they
choose all the Saws to return, I would like to have code that will look up
the corresponding Issue_ID and fill in the Date_Returned for each Saw chosen
for returning with the current date.
Any help would be greatly appreciated
Thanks
Steve
satellite facility. It contains 4 fields:
Issue_ID - Auto Number
Date_Issued - Date Field
Saw_ID - Item Serial Number - Text
Date_Returned - Date Field
What I am trying to do -
I have one form that has a list box that lets the user choose which Saw_ID
they would like to issue and once they choose them and click the issue box it
creates new records containing an Issue_ID, the appropriate Saw_ID and todays
date for the Date_Issued field.
I have a second form with a list box that contains the Saw_ID's that have
been issued but the underlying info is bound by the Issue_ID and once they
choose all the Saws to return, I would like to have code that will look up
the corresponding Issue_ID and fill in the Date_Returned for each Saw chosen
for returning with the current date.
Any help would be greatly appreciated
Thanks
Steve