rsbutterfly16
Registered User.
- Local time
- Today, 09:45
- Joined
- Jun 5, 2006
- Messages
- 77
I have a question I hope someone can help me
I have 5 parameter query that gets its value from 5 combo boxes from a form
The
following function is in the criteria grid for one of the fields:
Like NZ([forms]![searchform]![combo69],"*")
when I enter data for a combo box for one of the combo boxes then if there is a null value in another one of the parameters combo boxes then it does not show. so I tried this:
Like NZ([forms]![reports_switch_main]![combo70],"*") or is null
but then when i run the form and i put an value in one of the combo boxes if there is a null value in the results it shows also, i don't want that. My form has 10 columns in which some have data and some dont for all rows
is there any way to do this? help!
I have 5 parameter query that gets its value from 5 combo boxes from a form
The
following function is in the criteria grid for one of the fields:
Like NZ([forms]![searchform]![combo69],"*")
when I enter data for a combo box for one of the combo boxes then if there is a null value in another one of the parameters combo boxes then it does not show. so I tried this:
Like NZ([forms]![reports_switch_main]![combo70],"*") or is null
but then when i run the form and i put an value in one of the combo boxes if there is a null value in the results it shows also, i don't want that. My form has 10 columns in which some have data and some dont for all rows
is there any way to do this? help!
