By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,008 Members | 2,962 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,008 IT Pros & Developers. It's quick & easy.

Show another item in table based upon what user selects.

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jv
-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)

Nov 13 '05 #2

P: n/a
Brilliant. That worked thanks alot!!! :)

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.