ms access question

[113518r]

Hi
i designed ms access program which work with a bar code but after i scan item code to the form automatically i want to get data to the fields of description and price
how can i get data of this fields after i scan item code
to the form? is there a code that bring data to the form fields from the tables or queries?
how can i get the data automatically after i scan item code?
thankyou!

 

[jrbarnett]

You need to use the AfterUpdate event of the control that holds the barcode, then use the DLookup command to retrieve the appropriate values from your database and display them on your form.

John