Filter within a filter

[TTD]

Hy,

is it possible to filter within a filter on a form?

Let's say I have a button which can filter on only open cases and another
button to filter on only my cases, then if I pushed both buttons, I would
get only my open cases.

I thought of doing such so with this code, but VBA was not impressed.

Me.Filter = "tblCases.Ready = False" & "tblCases.Owner = " & LoginUser
Thanks in advance.

[Salad]

TTD wrote:

Hy,

is it possible to filter within a filter on a form?

Let's say I have a button which can filter on only open cases and another
button to filter on only my cases, then if I pushed both buttons, I would
get only my open cases.

I thought of doing such so with this code, but VBA was not impressed.

Me.Filter = "tblCases.Ready = False" & "tblCases.Owner = " & LoginUser
Thanks in advance.

You forgot the word AND then you forgot quotes unless your login user is
a number

Me.Filter = "tblCases.Ready = False AND " & _
"tblCases.Owner = """ & LoginUser & """"

or

Me.Filter = "tblCases.Ready = False AND " & _
"tblCases.Owner = '" & LoginUser & "'"

Dates, surround with #. Strings, surround with ' or ". Numbers
surround with nothing.

[TTD]

Thanks,

it was the right direction...
Me.Filter = "tblCases.Ready = False AND tblCases.Owner = " & LoginUser

was the right formula.

Also thanks for the date tip!