How to choose when parameter's applied in query

[Guest]

I've built a search form with about 15 controls, and I want to use those
controls to set parameter criteria for a query. But I don't want users to
have to select a value for every control, just whichever one(s) they want to
limit.

If they leave a control blank, I don't want to lose all the records in the
resultant query, NOR do I want to include an "Is Null" statement in the OR
section of the Query design, because that will just return every record if
left blank.

What I need is something that will retrieve criteria if users select/enter
it in the form, but will otherwise treat the field as if the criteria is
blank.

Is that possible?

 

[Guest]

Hi,

Allen Browne wrote some code to do something similar to what you want to do
I think. He used his code to apply a filter to a form, but I don't see why
you couldn't use it to make a SQL statement and run it in VBA as a Query Def
or by using the runSQL command.

http://allenbrowne.com/ser-62code.html


Hunter57
Just huntin' for some data.
http://churchmanagementsoftware.googlepages.com