I have designed a database controlled by one main form. There are several search buttons on the form, all searching for different groups of records.
I would like to make the search buttons cumulative, so that if I press search button 1, it will return all records that satisfy that property; if I then press search button 4, it will return all records that have the properties of both search buttons 1 AND 4.
Does anyone know how I can achieve this (preferably as neatly as possible)?
I would like to make the search buttons cumulative, so that if I press search button 1, it will return all records that satisfy that property; if I then press search button 4, it will return all records that have the properties of both search buttons 1 AND 4.
Does anyone know how I can achieve this (preferably as neatly as possible)?
