Filling in text box from table

B

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
 
M

Marshall Barton

BWolf said:
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.
Click to expand...


"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?
 
Top