• Open report after filter (Access 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Open report after filter (Access 2000)

    Author
    Topic
    WSsolar
    AskWoody Lounger
    February 21, 2007 at 6:05 pm #439978

    I can filter a form but how can i open the report after the filter ? In the attached example i cannot do it

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      February 21, 2007 at 6:31 pm #1052752

      You have put code in the On Open event of the report to set its RecordSource, but you only do so if Office is 3. Why?

      Reply | Quote
      • WSsolar
        AskWoody Lounger
        February 21, 2007 at 8:34 pm #1052785

        sorry office = 3 was juts a trial.i omitted to delete it

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          February 21, 2007 at 9:05 pm #1052791

          You should use code in the On Open event of the report similar to the code you have for the On Change event of the option group on the form.

          Reply | Quote
    Viewing 0 reply threads
    Reply To: Open report after filter (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.