Cascading combo box updating text box?

[RemonKoybito]

Hello all. So I'm redoing my non-profit's inventory database and I managed to figure out how to make cascading combo boxes to pick the category (Adult, Infant, etc.) and then the items for those categories. Now, I need a text box to automatically put in the item value, depending on the choice picked in the second combo box.



I have all the items listed on one table, listed with Category, Item, and Product Value. I need this on the form I'm making that's linked to the Inventory In table.

Thanks for your help!

[TheShabz]

put
me.txtBoxName = DLookup("fieldValue", "tblName", "itemID = " & me.comboBoxHoldingItemID)
in the afterUpdate event of the combobox that displays the item.

txtBoxName is the name of the textbox you want the value displayed in.
fieldValue is the name of the field that holds the value of the item you want.
tblName is the name of the table that holds this data.
itemID is the ID (likely the primary key) of the item in question. This should be whatever data the combobox is holding. I'm assuming the combobox has 2 columns, ID and Name with the ID hidden. If not, just use whatever field is help by that combobox.