Multiple combo boxes to filter subform

[dustweb]

I have 3 combo boxes: Customer Number; Control Number; Customer Name. I want to be able to filter each one of these fields seperatly to a subform.

Right now I have a form that is linked to a qry. The subform is also linked to the same qry.

My problem is that when I set and event on "After Update" it is not filtering the criteria selected in the subform.

Ex: I select Customer number "1234" the macro does not filter the subform to show customer number "1234".

Any help is much appriciated. Thank you in advanced.

Dustweb.

 

[Norie]

Try using the Requery method on the subform.

Check help for full details.

 

[dustweb]

Thanks I 'll try that.