Auto Populate TextBox when choosing from ComboBox.

[FlabbyRoach]

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

[pbaldy]

Does this help?

BaldyWeb - Autofill

[FlabbyRoach]

Sorry pbaldy...that did not work.

[pbaldy]

"did not work" is very vague. I can assure you it does work. What exactly did you try?

[FlabbyRoach]

LOL sorry about being vague
=[Operation_ID].[ColumnCount](2)
this is what I used
I did not try the other code yet
But I do not have two tables that I am getting info from or maybe I read your instructions wrong.

[FlabbyRoach]

this is the code for my combo box
SELECT OperationsT.Operation_Description, OperationsT.Operation_Numbers FROM OperationsT;

[pbaldy]

As noted in the link, the Column property is zero based, so you'd want 1 for the second column.

[FlabbyRoach]

I hate to be vague again but
=[Operation_ID].[ColumnCount](1)
Did not work either - I get #error in the text box

[pbaldy]

It's Column, not ColumnCount.

[FlabbyRoach]

Thank You
That did the trick.
Sorry to trouble you.
Problem solved
I'll read more closely next time.

[pbaldy]

Happy to help. You had it in post 5 too, I should have noticed it then. Saw the 2 and stopped looking.

[FlabbyRoach]

How do I put solved on the thread?

[pbaldy]

It's in Thread Tools at the top of the thread.

[FlabbyRoach]

thanks again

[FlabbyRoach]

Sorry to bother you again.
The sub form I was using was supposed to update a table I am using for a query.
Do I need to do something else to update the table?