HOW DO I SEARCH ALL RECORDS, DEPENDING ON CERTAIN REQUIREMENTS

E.G

USING A MIXTURE OF COMBO BOX, CHECK BOX AND OPTION BUTTONS SELECT RECORDS THAT MEET ANY OF THE SELECTED ITEMS.

E.G LOOKING FOR A HOUSE FOR EXAMPLE, THAT IS RED, IS BIG AND IS OLD, OR IS ANY OF THE ABOVE

THE CHOICES WILL BE GIVEN IN THE CHECK BOXES.

I KNOW THIS CAN BE DONE BUT WRITING THE CODE
IS SEEMINGLY IMPOSSIBLE

http://www.access-programmers.co.uk/ubb/Forum3/HTML/003230.html may help you get started. There are other links within it.
Your question is extremely broad so it will be difficult for people to help you without more information on what you want to do, and how you can do it.

David R