H
hermanko
Hi,
I have a form on which I would like to create two combo boxes, filled
with a fixed number of queries in a Value List on both combos. The goal
is to have the user select from a list and then select a different
query on the 2nd combo, then hit a cmd button to execute a comparison.
For this setup, i require both combo boxes populated with identical
lists of queries (i.e. A,B,C in each drop down list). What I would like
to have happen is if the user selects "A" from the first combo, i want
the "A" removed from the second list (since the goal is to comparison
across two DIFFERENT queries), showing only "B" and "C" available for
the 2nd box.
Right now all i can manage is entering my values in the RowSource field
for each combobox property, but the user is able to select "A" and "A"
from each which i want to avoid.
Also, what is the most efficient way to do the actual comparison
between 2 queries, when the user has the option of severa different
combinations (i.e. A and B, B and C, etc)...do i have to create another
query that compares between 2 queries for ALL permutations? Or is there
a way to keep it to just one additional query, using variables that get
passed from the user selections on the form?
Thanks in advance!
Herman
I have a form on which I would like to create two combo boxes, filled
with a fixed number of queries in a Value List on both combos. The goal
is to have the user select from a list and then select a different
query on the 2nd combo, then hit a cmd button to execute a comparison.
For this setup, i require both combo boxes populated with identical
lists of queries (i.e. A,B,C in each drop down list). What I would like
to have happen is if the user selects "A" from the first combo, i want
the "A" removed from the second list (since the goal is to comparison
across two DIFFERENT queries), showing only "B" and "C" available for
the 2nd box.
Right now all i can manage is entering my values in the RowSource field
for each combobox property, but the user is able to select "A" and "A"
from each which i want to avoid.
Also, what is the most efficient way to do the actual comparison
between 2 queries, when the user has the option of severa different
combinations (i.e. A and B, B and C, etc)...do i have to create another
query that compares between 2 queries for ALL permutations? Or is there
a way to keep it to just one additional query, using variables that get
passed from the user selections on the form?
Thanks in advance!
Herman