how to access data to a text box using a combo box

[jensonchandy]

hi all

i'm doing one access project
the forms are also designed in access

i'll come to the issue
there is one form for employees
in that i'm using a combo box where i can see the details of their designation
these designations are already stored in another table
when i select a designation code, i want to display the designation name in a seperate text box.
how can i do it...
is it any thing to do in the codings
or can i do it thru expression builder
i need an urgent reply

regards
jenson

 

[ColinEssex]

If you have the designation code and description in the ComboBox list, why not have the description displayed in the comboBox after its selected? Does it need to be displayed in a seperate field?

Col

 

[jensonchandy]

If you have the designation code and description in the ComboBox list, why not have the description displayed in the comboBox after its selected? Does it need to be displayed in a seperate field?

Col

i need both in two different boxes. b'coz i've to save the designation in another table and the designation name should come in the report also. while i need the code also for salary calculations