COMBO BOX CHANGE

  • Thread starter Thread starter RAF
  • Start date Start date
R

RAF

I am new at this... HELP I have a combo box which I use to
fill in the options in a second combo box. If I decide to
change the first one I can't get the options in the second
one to change. It wants to stay th same as the first query
gave. I know this must be easy but I have tried everything.
 
Dear RAF:

I believe what you want is accomplished by defining a hierarchy of
combo boxes (often called "drill-down") in which the combo boxes are
accessed in a specific order, each one filtering the list shown in the
next according to what has already been selected.

In the Click event of each combo box, build a new SQL string to be
assigned to each of the combo boxes that depend on that selection,
filtering as appropriate.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Hi,

I was wondering if you would help me out with the SQL string for these
drill-down combo boxes. I am unable to figure the coding out. What would
help is a working example.

Thank you,
Leo W
 
Back
Top