Filtering form

[samotek]

I need to filter a form per 2 criteria : per month and per office.How could I do it with both of them ?
The record source of the form is :
SELECT TblClients.ClientID, CallsClients.CallDate, TblClients.afid
FROM TblClients INNER JOIN CallsClients ON TblClients.ClientID = CallsClients.ClientID
ORDER BY CallsClients.CallDate;

I have also 2 option groups.The first option group is called Monaten with 12 options for the months. The second option group is called office with 10 options. The first option is afid = 1, the second is afid = 2 etc.

The controls on the forms in a simplified mode are :
Clientid, call date, afid

 

[PHV]

Something like this ?
Me.Filter = "Month(CallDate)=" & Me!Monaten & " AND afid=" & Me!office
Me.FilterOn = True

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886