How do I use pass query values to a form?

M

Mike

I am using a form as input to append records to a table. The first input
field on the form contains a product ID embedded in the scanned data. I would
like to verify that the scanned data contains an actual product ID match by
using the event On Exit to run a query that would find a ID match and
populate a field on the same form with a display field of the record it
finds. I tried using the Control Source = to a field in that query but I
don't get a field to display only #Name?. Can you help
 
N

NetworkTrade

one method is to put an unbound combobox in your form and source that on the
query.

then when you 'OnExit' or 'AfterUpdate' the scan field - put in VBA to
requery that combobox.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top