Script to perform find in one field then automatically insert date in another field
I have an inventory database where when I check things in I want to perform a search on the item's barcode (using a barcode reader). If the item is found I'd like it to automatically place today's date in the Returned Date field. After the date is added I want the form to reset in order to take the next item. If the item is not found I want an error message that reads something like "Item not found".
Their are really only two fields: Barcode and Returned Date
I am a novice at scripting but have written a couple very simple ones. So I am confused about how the easiest way to accomplish this. Any advice would be appreciated.