Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2001
    Location
    Bethlehem, Pennsylvania, USA
    Posts
    67
    Thanks
    0
    Thanked 0 Times in 0 Posts

    filtering combo boxes (access 2k)

    I have a form that has two combo boxes. One has states and the other has cities. Is there a way that once I select a state the cities combo box get filtered for only those cities in that state?

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Location
    Illinois, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filtering combo boxes (access 2k)

    In the query behind the Cities combobox add a column for the State with a criteria that the State would equal the value of the States combobox. So the criteria would look something like this for the State field: Forms!frmCityStateSelect!cboState. Then in the after_update event for the State combobox you would requery the City combobox: Me!cboCity.Requery

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •