I have a form that has three dropdown choices. All the choices are fields from the same table. My search works if all three boxes are used, how do I make the fields optional so if a person only wants to search on one or two of the choices it will run the search???
I tried to do this is vba, using querydef but I couldnt figure out the exact syntax to use to create a querydef. I am pretty sure I can create a SQL statement to collect what I need, but I can't figure out how to run it.
Please help, it seems like something so easy and its becoming a pain in my butt.
I tried to do this is vba, using querydef but I couldnt figure out the exact syntax to use to create a querydef. I am pretty sure I can create a SQL statement to collect what I need, but I can't figure out how to run it.
Please help, it seems like something so easy and its becoming a pain in my butt.