Fill textboxs with data from a query

[Bkgabbert]

Hello,

So i am trying to get data from a query into a textboxs. I have one form with two textboxs on it. One is for a part number the other is for a part description. I scan a barcode to get the part number into the part number textboxs, but then I want to use a query with the part number to get the part description into the other textbox. I can get it if I change the second textbox to a combo box, but then I have to choose it from the list. I must be missing something, can someone please help. I haven't used access in about 6years so maybe something has changed sice last time I used it.

Thank you
Ben

[June7]

Options:

1. Form RecordSource is a query that joins tables so the related info from parts table is available. Bind textboxes to fields of parts table and set properties Locked Yes and TabStop No.

2. The part number control is a multi-column combobox with part number and part description. Textbox ControlSource expression refers to the column with the description.