Update one combo based on another combo

  • Thread starter Thread starter Tara
  • Start date Start date
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
 
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
 
Back
Top