Using SQL to choose display information in a text box.

[jalge2]

Hey all. I've got a combo box showing part numbers and descriptions. Beside the combo box is a text box. I'm trying to select something out of the combo box and have the part number stay in the combo box and the description show up in the text box.

I have two tables dealing with this, my inventory table and my main table that holds all information. The inventory table is simply the list of all parts and part numbers.

My subform that contains this sql statement

SELECT Inventory.[Part Number], tblService.Description, Inventory.[Qty on Hand], tblService.Comments FROM Inventory INNER JOIN tblService ON Inventory.[Part Number]=tblService.[Part Number];

I created this by using the query builder and was wondering if someone could help me out and tell me what I'm doing wrong. Thanks a lot.

Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'

 

[cmmrfrds]

The item and description are in the combobox and when onclick show the description in the textbox?

OnClick event

txtboxname = cbname.column(1) '- relative to 0
requery.txtboxname