Combo box as a search tool.

[obheron]

Hi all,
I have a form being used as an input form. I have a few fields originating from the forms record source. One of these fields is a combo box.
I am wondering how I get two of the other fields to update based on the choice of the combo box? I.e. 73, orange, and blue are an entry in the record soure, so when I choose 73 in the combo box I want orange and blue to show up in the related fields.

Thanks in advance.

Obh

 

[KenReay]

Sounds like you need to base the combo on a query joining the two tables. Make the combo a multi column combo, then you can populate controls on the form with code like =MyCombo.Column(1) in the Sorce property

Regards

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

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

UK