Search field from a textbox

[AndyMarshall]

Complete newbie needs help.

TABLE
Field 1 = Barcode (Text)
Field 2 = Name (Text)
Field 3 = Picture (Object)

when creating a form from the table above, I want to enter barcode information (Text) in a text box and then I want this to display the information that is contained for that barcode. i.e if the barcode data is read in the textbox TEST for example when I press Return I want the Name and Picture that Test refers to to be displayed on the screen, any Help?

Thanks Andy.

 

[DreamerZ]

Create a query with the 3 fields from the table. Set the Criteria to the Barcode entry text box.

Then on click of the Return button, open a new form or subform that has a record source of the query.

That should work.

DreamerZ

 

[AndyMarshall]

Thanks DreamerZ,

I will give it a try and let you know.

Andy.