Parameter query value question

[razorking]

Not sure if anyone has an answer for this, but any feedback will be appreciated.

I have a database with a parameter query that uses a table for it's source data.

When the box pops up to enter a parameter value I scan a barcoded item serial number label into the parameter box. If the serial number is on the table a window pops up and shows detailed data relating to the scanned serial number.

Sometimes there items (with barcoded serial tags) that are not on the table. When that happens nothing pops up in the results (obviously).

The question is:
I want a way to capture the scanned serial number that does not have a matching record on the source table, and I want to populate this record to another table in my database. This way I can review all the items not showing in inventory at a later time.

I hope I am making sense.

Anybody have any ideas on how one begins to accomplish this?

Thanks!

 

[pbaldy]

I would use a form rather than the simple parameter box. That way, you have the value there you can work with. I wrote an app that used a card swiper, and if your barcode scanner works similarly, you can use the after update event of the form control to check the number, and either open the query/form or populate the other table, as appropriate.

 

[razorking]

I would use a form rather than the simple parameter box. That way, you have the value there you can work with. I wrote a app that used a card swiper, and if your barcode scanner works similarly, you can use the after update event of the form control to check the number, and either open the query/form or populate the other table, as appropriate.

Thanks for the tip. Sounds like a good starting point. I will see what I can do.