Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    14

    Unanswered: VBA equiv. of Filter By Form

    I want to add a button to my form that when clicks uses the same functionality as the Filter By Form in the icon bar. Does anyone know how to do this?

    Thanks
    Keith

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    try
    RunCommand acCmdFilterByForm

  3. #3
    Join Date
    Apr 2004
    Posts
    14
    that work great. As a follow up to this. I have an Apply Filter button ON the form. When I slect Filter By Form the Apply filter button get greyed out and becomes inactive. How do I keep it active so the user can apply the filter?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •