Query using checkbox??

[Beaconite]

Ill try to explain this as best I can, I am no expert in Access and with what little experience I had, I was given this project. Ill add screen shots as best I can to show what im trying to do.

Basically what this project is, is a foster care data base, where someone can input kids (with certain attributes such as age, male/female, any health problems) and match them with houses that accept those kids with the criteria, such as this house accepts children from ages 0-17, with health problems, don't want them if they are sex offenders or fire starters, etc.

I have a form for setting up new reservations kind of like a hotel system.
looks like :

when someone hits the "SEARCH HOMES" button, it opens this form where they can select the kids criteria such as male, age, etc.

At this point is where I get confused. On the form for selecting criteria, I need a query to run and basicly "match" houses that accept this criteria. The table that the house profiles is on looks like:

So when the "run Query" button is selected on the kids criteria button is selcted I need a macro that takes the information put into the form, runs the query, and "matches" the homes.

Again, I am no expert at access and if you could help me out ASAP the deadline is already past due.

final product i need this query to report in a sub-form on the first picture shown under available houses, but im pretty sure I know how to do that. all i need to know is how to creat this query to take the inputs on the form about the child, and match it with the homes that accept that criteria.

Please help fast!!
Thanks for your time and patience.

 

[Kafrin]

It looks like you can just match up the fields. It depends exactly how the child's details are stored in the table, but as long as you're going to have the SelectCriteria form open (or another form that has this data behind the scenes) and on the right record when you run the query, here's what I suggest...

Start a new query and add just the HouseProfile table.
Work out which fields you're going to want to actually show for each house and add to the query fields.
Add the Male field. Untick the Show box. In the criteria line for this field, type something like:
forms![F-SelectCriteria]!Male
...This will mean that you only see House records where the Male field is the same as the Male field on the SelectCriteria form.
Repeat for the other fields.

 

[Beaconite]

Okay, I think I can figure that out, if you want ill send you an email with the data base in it, and you can show me what you mean. That would help a lot, and thank you so much for the fast response. My email is ds58408@salisbury.edu if you wanted to shoot me an email and I could send it over to you to view real quick. Again, thank you for your time.

 

[Kafrin]

I did email you but haven't received a reply. I'm about to disappear for the weekend I'm afraid. I can pick this up on Monday if you like, otherwise good luck putting it together, I hope you get it sorted.