Search using combo-box

[lukker234]

I am very new to Access and i have a problem, i have a table with information in it and i have to search in that table using a few combo boxes.


but i am stuck at 1 point and that's when i press the search button i only get all the information from the table and not the information that i have selected using the combo-box.

i hope that somebody can help me because i am stuck with this problem for a long time now.

[June7]

If you want to use comboboxes to enter filter criteria, must do this on a form, not in table.

For one method review
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...earchform.html

[lukker234]

i'am sorry, i use a form to enter the filter criteria but after i selected all the information in the comboboxes the only result is that i get all the data from the table and not the one that i asked for in the form.

[June7]

What method are you using to accomplish the filter? Have you tried the method shown in tutorials? Show relevant code for analysis.

[lukker234]

this is the situation now:
- i have a table called "Dog"
- from that table i have a query called "Dog Query" in here are a few rows
- Gender
- Born
- Can it go in a car
- Name
- and i have a form called "Dog Form" and here are the combo boxes with the options from the Dog Query

using this form and selecting the options from those 4 data rows, i want an new form popping up and giving me the result ( with a few dogs that meet the criteria that i gave using the combo boxes)

i'm sorry for the way of explaining but i'm very new to this and its a school assignment

i hope you can help me with this.

i didn't used codes because i don't know what to write to get it to work, that's why i came to this forum.

[June7]

The tutorials I referenced demonstrate technique to do that. Apply the technique to your situation.