Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Thanked 0 Times in 0 Posts

    Filter (Access all Versions)

    I have created a form with a number of fields and about say 300 records which are clients.
    There is a command button attatched to each record so that the user can drill down into further detail about the client
    I apply a filter on these records and scroll down to find a certain client and then click the command button to drill down into the client detail.
    The first form then closes and a new one opens with the drill down detail of the record.
    When i click back and return to the original form, the filter I applied has gone and I am back at the first record.

    How do I Is it possible to return to the first form and have the filter I applied and the record I was at still active so I do not have to re-apply a filter and scroll again?

    Hope this makes sense.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Filter (Access all Versions)

    Instead of closing the first form, you can leave it open. If you open the detail form as a dialog (by setting the WindowMode argument of DoCmd.OpenForm to acDialog), the user cannot click back in the first form, he/she must close the second form.
    If you don't like the first form to remain visible behind the second form, you can hide it by setting its Visible property to False. Set its Visible property to True again when the second form is closed.
    By leaving the first form open (even if hidden), the filter remains set, as well as the current record.

Posting Permissions

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