Subform Filter with Multiple Criteria

  • Thread starter Thread starter Zilty
  • Start date Start date
Z

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'
 
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'
Click to expand...

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

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