Linking Controls in a form

[meliorexi]

Hi

I have created a form based on a single table. Two of the controls are related and I want one to return a result on one control based on the selection (from a combo box) that the user makes on the other.

For example, if the user selects COMM from a combo box in one control, I want the other control to return "Communications", which is the full description for COMM.

Any help greatly appreciated.

Cheers

 

[KenReay]

Hi

Have a table:

Id
Desc

this table would have rows so

COMM Comunication
...etc

base you combo box on the table, have two columns, Id and Desc in that order, set column widths to 1,0 (ie hide the second column)

have a text box, sets its recordsource to = MyCombo.Column(1), where MyCombo is the above mentioned combo box

One may aslo ask why?

if you set the column widths on the combo to 0,1 you can show the description but store the code

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK