Multiple Linked ComboBoxes

[OzSupra]

I have code that sorts a second combo box based on the value for the first combo box. What I can't seem to get a grip on is then sorting a third, fourth, etc.
What I am attempting to do is create a decision tree based on selections previous entered by the use.

Any help would be appreciated.
Thanks in Advance,
Adrian.

 

[KenReay]

Hi

Are you saying that combo2 is sorted depending on the value of combo1 and that combo3 is sorted depending on the value of combo2 etc...

If so surely it is just more of the same code and query adjustment you have already used, just with different combo box names?

Regards

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

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

UK

 

[OzSupra]

Yep! that's exactley what I'm saying. Except it does work using the code on the FAQ page. Once yo cange Combo1 all saved records for combo3 become blank.

Adrian.

 

[KenReay]

Hi

Post your code please so I can see it

Regards

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

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

UK

 

[OzSupra]

Thanks Ken,

I think I just worked it out by writing down the problem and structure to you.
Amazing what a bit of code review can do! My problem was that I was storing a reference and not the actual value.

Cheers,
Adrian.

 

[JohnHarkins]

Please share your insight (i.e., the code) with the rest of us. We could all learn something, I'm sure.

John Harkins