Hi,
Currently I have a query where 5 control boxes all the user to select different criteria for a selection of records. This scenario is used with a split form. On the selection part of the form I can enter text in any one or all of the control boxes and the records matching that criteria display in the bottom part of the form. On bottom form (a list), the tempvars as criteria use this format:
Field - SName
Criteria - Like "*" & [ShelterCounty] & "*".
Again, five fields have the same format.
Everything works fine.
Now, I've tried the same with a report. I use 4 combo boxes and tempvars and use the same Like statement, Like "*" & [TempVars]![TempCounty] & "*" as above for the report. However, if I leave one combobox without a value, I get no records. If everything has a value, it properly selects the correct records.
As I'm writing this I'm wondering if the control box vs. a oombo box is an issue, or is something built into the split form that I am missing.
Any help would be appreciated.
Maybe this would be better said as follows:
I'm generating a report. The selection criteria for the report are four items. City, State, County and Facility Owner. Only one is necessary for the report to run, however I could also select values for all for items. I want to do this from a macro, however I'm open to VBA code.
Jeff
Jeff