Multiple dependancies for a cascading combo box

[tcveltma]

Hi Everyone,

I have a cascading combo box, where you choose a general topic, and the next combo box only shows the related options....easy . Now I'm being told that one of the options I have can only be visible when a different combo box has a certain option. The table I am drawing form is not really set up to add to my SELECT statement, so I'm basically looking for a code along the lines of

Forms!FormName! ComboBox.ItemDa ta(0).Visible = False

Is there any way to do this? So far, I have been getting a bunch of syntax and run-time errors trying to do this.

Thanks,
Tiffany

[Rabbit]

That option doesn't exist. You'll just have to modify your cascading code to take into the account this new condition.

[tcveltma]

Okay, thanks :)

Tiffany

[Rabbit]

Not a problem, good luck. Let us know if you get stuck somewhere.