I am looking for some help/advice in programming an option button in a form.
Specifically, I have a form with a combo box and 2 text boxes.
The combo box contains a list (Vendor), and the text boxes are used to input a date range, and a command button to run everything. These are tied to a query which contains all of the records. Enter the "Vendor" number, start date and end date and click the OK button. The query runs and returns only records for the search criteria... works great. The idea was for anyone to export the results to excel and do what they want with the data... but now someone wants to click a button to apply a filter (laziness if you ask me), anyway, I'm not quite sure of the best way to do it. If the button is active, the filter is applied, if not active, the filter is not applied.
I have attached a sample DB. I don't know if I should use code, an expression or..... Either way, I'm fairly new to Access and VBA and am a bit stumped. Thanks