Find and update multiple values

[chemthethriller]

So, I'm fairly new to MS Access and I'm trying to build an inventory db for my company. We also take equipment and setup small networks at other locations. I would like to create a form that I could enter multiple Serial numbers and check them out.


For instance my Database at the moment is just Serial Number, Location, Technician, Checked in/out, and Timestamp (of last move).
So I would like to enter in S/N 1, 2, 3, and 4 (up to maybe 60) click a check out box, add a new location, and new technician and have all those records in the DB update.
At the moment the best I can figure out is a CTRL+F, find the SN and edit all the data manually which is very time consuming.

[June7]

Check in/out sounds like the MS Lending Library database template. MS also offers an inventory database template.

For one method of searching for dynamic number of multiple values of the same field, review: http://www.allenbrowne.com/ser-50.html

Could use a textbox to input comma separated string of S/N numbers for use with IN operator, but if user errors in typing, the filter will fail.

[chemthethriller]

Well user should never have typing errors due to us using barcode scanners for the input to MS. I'll read over the link you gave me, thank you!

It's definitely a check in/out I looked through the MS templates available in Access and nothing really accomplished exactly what I was looking for.

[June7]

Seldom does any template do exactly what you want but can get ideas.

The barcodes would still have to be separated by commas for the IN operator. The alternative is a series or OR expressions:

[barcode] = 34534343 OR [barcode] = 97976589 OR etc

or

[SN] = 1 Or [SN] = 2 OR etc