Subform Filter with Multiple Criteria

[Zilty]

Hi all,

I've got a subform and can filter via this code:

frmSUB.Form.Filter = strFilter
frmSUB.Form.FilterOn = True

But, it only works with a single criteria, so when strFilter =
something like

[Application] = 'ProgramA'

If I try multiple criteria, I get error 2448. Something must be wrong
w/ my syntax, but I don't know what it could be. Anyone got any
ideas? Thanks in advance -

[Application] = 'ProgramA';[Profile] = 'AMAS'

 

[Zilty]

Hi all,

I've got a subform and can filter via this code:

frmSUB.Form.Filter = strFilter
frmSUB.Form.FilterOn = True

But, it only works with a single criteria, so when strFilter =
something like

[Application] = 'ProgramA'

If I try multiple criteria, I get error 2448. Something must be wrong
w/ my syntax, but I don't know what it could be. Anyone got any
ideas? Thanks in advance -

[Application] = 'ProgramA';[Profile] = 'AMAS'

Aha - just found it. Instead of a semi-colon, seperate multiple
criteria with AND.

[Application] = 'ProgramA' AND [Profile] = 'AMAS'