I'm not entirely sure on how to work this but,
How would i create a form/script that would update a record with the current date+time a field based upon the data in another field.
----------------------------------------------------------------
Example:
I type in a PGID into a form drop down box and press enter.
The form finds that record and enters current Time and Date.
----------------------------------------------------------------
We are using a barcode scanner to input the PGID into the form.
This form is being used to turn in items, and we want to keep a history of all items turned in and when they were turned in.
Thank you for your help!
EDIT: Using Access 2003 on WindowsXP Pro
How would i create a form/script that would update a record with the current date+time a field based upon the data in another field.
----------------------------------------------------------------
Example:
I type in a PGID into a form drop down box and press enter.
The form finds that record and enters current Time and Date.
----------------------------------------------------------------
We are using a barcode scanner to input the PGID into the form.
This form is being used to turn in items, and we want to keep a history of all items turned in and when they were turned in.
Thank you for your help!
EDIT: Using Access 2003 on WindowsXP Pro