Update one combo based on another combo

T

Tara

Hi! Quick question for the group...I have a combo box
that lists number of members in a family. I have another
combo box called "Income" that I need to be populated
with several different options based on the selection in
the first combo. For example, if a family has 3 members,
I want the "Income" combo to show the values $15,260 or
less, $30,520, and $38,151+. I don't want to use a query
on this one and I know there's another way to do it using
criteria in the combo's Row Source, but I can't remember
how. I've looked through the threads here but still
can't find what I'm looking for. Any help is appreciated!

Tara
 
T

Tara

Thanks for the suggestions, but I'm still not finding
what I need. I scrolled through quite a few of the
threads, but either I'm over-looking what I need or the
specific solution I'm looking for hasn't been addressed
in awhile. I specifically do not want to use a query.
What I'm hoping to do is put something in the RowSource
like "If combo a=2, then combo b=$15,000, $18,000,
$25,000" "If combo a=3, then combo b=$18,500, $23,000,
29,000". That's obviously not how to word it, but that's
the gist of what I need. I was pretty sure I've seen
this done this way somewhere, but I can't find it. Like
I said, perhaps I'm just over-looking it, so if I am, a
specific thread to look at would be very helpful. Thanks
again.
Tara
 
Top