Multiple filtering criteria with Button

[BasicSkills]

I am new to this (Access in gerenal) and hoping someone can help.

On my form I have 4 combo boxes, and 3 tick boxes. I want a button that
will search each field independantly, but if it is Null {or "(none)"}, it
skips to the next field. I want it to be able to do an AND search dependant
on what ever criteria the user selects. It could be just one field or all 7
of them. Does this make sense? Is this even possible?

I have no idea how to do this.

I have tried calling individual macros in the Builder 'RunMacro' one after
the other but this seems to just return the final macro, not all together or
even if there is something in the field. Can someone steer me in the right
direction please...

 

[Gina Whipp]

BasicSkills,

Might I suggest you haver a look at this Search database by Allen Browne...

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

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[BasicSkills]

Thanks for the link. The only way to do it is to write out the entir code?
You can do it in Macro builder? Im guessing its too complex?!

 

[Gina Whipp]

BasicSkills,

I would not even attempt that code using a macro as macros do have their
limitations, that code being at the top of the list.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm