INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Expose filter criteria in subform for use in VBA of main form

Expose filter criteria in subform for use in VBA of main form

(OP)
I have a main form and a subform.

I can 'filter' the data in the subform by using the arrow next to the column heading and selecting the filters I want to apply.

Is it possible to identify what 'filters' have been selected against the column so that it can be used elsewhere in vba code?

RE: Expose filter criteria in subform for use in VBA of main form

Dim strFilter As String
Dim frm As Access.Form
Set frm = Me.subformName.Form
strFilter = frm.Filter

Now you will have to look at the result, because you will likely have to do some string manipulation to get rid of the subform reference.

RE: Expose filter criteria in subform for use in VBA of main form

(OP)
As always, Thank you

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close