Show another item in table based upon what user selects.

Hi

On a form i have a combobox which gets its values using
SELECT [costcode].[code] FROM costcode;

These are a set of codes.

Once the user has selected a code i wish to store the department that
the code relates to in a textbox.

My table is called costcode and i have 2 fields code and department.

Can anyone help?

Cheers

-Change the rowsource of the combo box to SELECT code], [department]
FROM costcode;
-Change the column count of the combo box to 2
-In the AfterUpdate event of the combo box, put
TextBoxName=ComboBoxName.column(1)

Brilliant. That worked thanks alot!!! :)