What is the best way to use a search form with an Access database. Currently, i have each search option with a radio button. I planned on using something like 'if radName.checked=true' then perform a SQL statement, and so on for the rest of the radio buttons. However, I do not know exactly to do this. Should I send the results to a datagrid on a new form? How do I pass each sql statement on to the datagrid?
any help would be appreciated. thanks.