Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open report after filter (Access 2000)

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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Open report after filter (Access 2000)

    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?

  3. #3
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open report after filter (Access 2000)

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

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Open report after filter (Access 2000)

    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.

  5. #5
    2 Star Lounger
    Join Date
    Sep 2006
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open report after filter (Access 2000)

    Yes I managed it now. Thank you !

Posting Permissions

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