changing criteria in a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field on a form that has 2 values: General Public or Media. I have
a combo box that lists all callers. It is populated from tblCallers. One of
the fields in the tblCallers is a true/false field entitled "Media". If
General Public is selected, then the combo box should populate with only the
callers where "Media" is false. If Media is selected, the the combo box
should populate with only the callers where Media is true. How do I get it
to do that?
 
See The ACCESS Web:
http://www.mvps.org/access/forms/frm0028.htm

The above article discusses how to filter a second combo box based on the
selection in a first combo box. It can be easily adapted to use a text box
instead of the first combo box if that is what you're using.

Note that the above article's code depends upon the user entering data in
the first control. If your setup is one where the textbox gets a value on
its own without user intervention, then the combo box Row Source query would
use the textbox in its WHERE clause.
 
Back
Top