use a different query/table in row source

[allenjasonbrown@gmail.com]

Hi.
I have a combo box and would like to use a different query for the row source based on a previous combo box.
Example:



[Combo Box 1]: = Ten

ROW SOURCE: [Combo Box 2]:
If [Combo Box 1] = Six then select distinct(names) from fullname.
If [Combo Box 1] = Ten then select distinct(names) from Total.
If [Combo Box 1] = Eight then select distinct(names) from Apples.

Is this possible? Thanks.

[pbaldy]

You should be able to adapt the row source method here:

Baldy-Cascading Combos