Unanswered: Search Form Using Combos and Multiple Fields
I am trying to create a search form for an Access 97 database (yes, my office still uses it). The database is attached and I have been designing it using Access 97. All I want is one search form that shows all of the fields from all three tables (which have been linked using certain fields) where users can select the criteria they want from the combo boxes. I would like users to be able to choose information from one field or multiple fields. Thanks.