Filtering using data contained in two combo boxes

[Gerimc]

I have a form which contains accounting data for different companies and for each year. I want to be able to filter by a year and then by the company and all the data for that particular selection will appear on the form in text boxes. How would I go about doing this? I have my combo boxes linked by but they don't filter anything.

 

[PaulF]

create a query to use as the Recordsource for your Form. Set the criteria row for the two fields picked by ComboBoxes to

Forms!YourFormName!TheComboBoxName



PaulF

 

[Gerimc]

When I do as you say here my form goes blank and I can't select form the combo boxes

 

[PaulF]

Place the ComboBoxes in the Form Header not in the Detail section

PaulF

 

[Gerimc]

My Combo boxes are in the form header area and my text boxes are in the detail section

 

[Hasu]

You might be get some idea from this FAQ faq702-3924


Hope this helps...
Hasu
(Trust on someone, someone will trust you!)

 

[PaulF]

Your Query SQL should look something like this

Select * from YourTableName Where Company = '" & Forms!YourFormName!YourComboBoxNameToSelectCompany & "' AND Year(YourYearField) = " & Forms!YourFormName!YourComboBoxNameToSelectCompany


PaulF