Searching marks field

[Wilson]

Hi there, Access Newbie who is getting there slowly.
I have created a database which is used as an inventory. I have created a search box so i can search for items by serial number. I am using a barcode scanner to input the serial number.
Is there a way once i have scanned/searched an item it marks the row or a field in that row so i can see if an item has already been scanned/searched for? Like a validation field?
A big thank you in advance

[pbaldy]

Probably, though it would help to know more about your structure and process. If the search box is bringing the record up on the form, you can simply set the value of a field to your desired value.

FYI, I deleted your duplicate thread.

[Wilson]

Hi there. I hope this explains it better. From the front end form i click on a button 'search by serial' This brings up a search box from which i can enter in a serial. It then displays a table (not form) with the relevant data in.

[pbaldy]

For starters, I never let users into tables or queries. You have little control over what they can do there, and no ability to have code there.

I don't know what code you use to perform that process (hint), but you might be able to add something to it that updates the desired field.