Filtering form

[samotek via AccessMonster.com]

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

 

[Jake]

put the word "AND" beteen them.

For example use:
Filter: month = 7 AND office = "HQ"
or in VBA:
Form.filter = "month = 7 AND office = ""HQ"""

Jacob