I have a sub-form that uses a table to populate a combo-box on the form.
The table has two fields and an auto number (ID) field.
So the Table has: Operation_ID (primary key & auto number)
Operation_Description (Short Text)
Operation_Numbers (Short Text)
The form works good as I choose from the combo-box but I would like to populate the textbox from the same table when I choose from the combo-box.
The item in the combo-box is related to the item that I want to see in the textbox.
Example: I choose Heat Treat from the combo-box which is ID #3 in the table.
The text box should display the "HT" from the same ID #3
I am sure it is a simple fix but I have been at it for a couple days now
Here is my small DB as well
ProcessSheets4-27-17.zip