Filling in text box from table

[BWolf]

Ok, so I know this is possible, but I seem to have had a brain fart
and cannot figure this out.

I have a table, 2 columns. One is the job description, one is the job
code. Each description has a unique 4 digit code.

On the form, I have a combo box that drops down with all the
descriptions. I also have a text box (that is locked) that will hold
the job code eventaully.

I want it so when you choose a job description from the drop down, it
fills in the job code automatically. I had a snipet of code writting
into the "After Update" event for the combo box, but it didn't want to
work right.

Please help....

-Brad

 

[Marshall Barton]

Ok, so I know this is possible, but I seem to have had a brain fart
and cannot figure this out.

I have a table, 2 columns. One is the job description, one is the job
code. Each description has a unique 4 digit code.

On the form, I have a combo box that drops down with all the
descriptions. I also have a text box (that is locked) that will hold
the job code eventaully.

I want it so when you choose a job description from the drop down, it
fills in the job code automatically. I had a snipet of code writting
into the "After Update" event for the combo box, but it didn't want to
work right.

"it didn't want to work right" doesn't provide a clue about
why the standard approach failed.

I don't understand why you need a text box. Are you aware
that what you see in a combo box can be the description at
the same time the combo box's value is the job code?