Filter using a Pop-up Form and Comboboxes
Hello!
I have a table in a database shows all expenses for several properties for one year. Some of the fields include: property, expense category, month, year, details, etc.
What I am trying to create is the following:
When I click to open a report, I want a little pop-up form to appear first to ask me what details I want to view from that table. I want the pop-up to ask about the property that I want to see the details for, the expense category to select (i.e. water, gas, telephones, etc.), the month I want to view it for and the year. If I leave the selection blank, it means all. For example, maybe I only want Vehicle Expenses for Property No. 1. Maybe I want all expenses related to Property No. 2 only. Maybe I want all electricity expenses for February of 2006.
Now...I have been able to do this using textboxes as the selection fields...however, I want this to be done using Combo box. I have made a query based on the details selected in the pop-up form, and if I use textboxes, it works perfectly. If I use combobox, nothing appears.
Any advice? Thank you!
|
