Link to home
Create AccountLog in
Avatar of PeterBaileyUk
PeterBaileyUk

asked on

determine if filter applied in access form

I am saving the state of my form, I have saved the filter property to a table:
CWlogRS.Fields("FilterMainFormSaved").Value = Forms![cw_client_matching_form].Form.Filter

I would like to determine if the filter is actually on, how do i determine that?

I am in vba
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Do you mean

If Me.FilterOn = True Then
  ' do something

?

mx
Avatar of PeterBaileyUk
PeterBaileyUk

ASKER

yes I need to save the filter state
i was stupidly looking for a property that wasnt listed
how do i reference that filteron when referencing a subform?
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
thank you and HPAAY NEW YEAR
*HAPPY