Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find a record in a report (2002)

    Is it possible to display a specific record in a report without filtering out all the other records? In other words, I'd like to display a particular record (based on user input in a form) but for the user to still be able to scroll through all the other records.

    I know it's possible to do this with forms, using FindRecord, but there is no FindRecord equivalent for reports. Or is there <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> ?!
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

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

    Re: Find a record in a report (2002)

    A report is not interactive in the way a form is. There is no way to do what you want in Access. As an alternative, you could export the report to Excel or Word, and search there.

  3. #3
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find a record in a report (2002)

    Thanks, <img src=/S/hansv.gif border=0 alt=HansV width=27 height=26>, feared that was the case.
    Now that's what I call a speedy response! <img src=/S/trophy.gif border=0 alt=trophy width=15 height=15>
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

  4. #4
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    181
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find a record in a report (2002)

    Hi

    Here is one way you can highlight a single field in a report via a form. Not sure whether it is fit for your purpose but it might give you some ideas. Otherwise it is as Hans stated.

    Regards
    WTH

Posting Permissions

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