2 criteria in ApplyFilter Statement?

[mbaddar]

Hi,

Does anyone know if it's possible to have 2 criteria in
an apply filter statement. I have 2 unbound combo boxes on
a form with a subform. One of the combo boxes is for
Catalog Number and one is for CatalogPage. After a user selects a Catalog and Catalog Page, all the Bill of Materials for that Catalog Page and Catalog should be displayed. So, I need to
have an apply filter that will only return
records from a particular Catalog and Catalog page.
Right now, this is what I have:
DoCmd.ApplyFilter , "CatalogPage = " & Pagecbo


Is this possible to add "Catalog = " & Catalogcbo?

Thanks,
MBaddar

 

[UncleJack]

Why not just set the RecordSource for the subform to a query that references the combo box contents in the criteria? The subform is supposed to requery automatically, but I've found that it doesn't always happen. So include a requery statement after you change the RecordSource.

Uncle jack

 

[mbaddar]

Thanks,

That is a good suggestion for the subform. However (and I'm sorry I didn't explain this well before), I also
have a header section on the top of the form where the information changes depending on what is selected
in the two comboboxes.

Thanks,
MBaddar

 

[UncleJack]

I don't see that as much of a problem either; what exactly are you having difficulty with?

Uncle Jack