How do I use pass query values to a form?

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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.
 
Back
Top