multiple filters

[aspnet98]

I am using the following code to set a filter on one of my forms:

Private Sub Form_Open(Cancel As Integer)
'Set unbound textbox = to login name.
Me.LoginName = strUserName

'Apply filter based on Username field.
Me.Filter = "[ReportsTo] = '" & Me.LoginName & "'"
Me.FilterOn = True

End Sub

I need to set another filter for Year. Can I set more than one, if so how? The field is called Year.

 

[Remou]

How about:
Me.Filter = "[ReportsTo] = '" & Me.LoginName & "' And Year=" & intYear

 

[PHV]

And, as Year is a reserved word:
Me.Filter = "ReportsTo='" & Me.LoginName & "' AND [Year]=" & intYear

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886