I've seen many questions on this and can't quite follow.
I have a data1 recordset (Access) and want to view only records that meet certain criteria, lets use zip code for example. I would like to use a filter and view all zips in the data control that match the query. I am using a combo box to select the criteria for the filter. Can anyone walk me through this using Combo1 and data1 as the objects, address.mdb as the database, table1 as the table and zip as the field to query.