in the attached Sample database, I have a form "frmProvider". I would like to give the user the ability to filter on one or more criteria and then have the form only show the records that meet that criteria.
i created 4 unbound combo boxes and can not figure out a way if the user selects more than one combo box to filter on each criteria selected.
Also on the state filter combo box its not working correctly either.
i have attached the sample database if this helps.