Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92

    Unanswered: stop form open as filtered.

    Im using the following to open a client record after doing a search using search form.

    DoCmd.Openform "frmReferrals", acNormal, , "[DIMAID] = " & lstFound.Column(0)
    Me![lstFound] = ""
    DoCmd.CLOSE acForm, "frmSearchCust"

    After the user clicks on the client in the list box on the search form, the client record opens as filtered. Is there there any way to stop the client form opening from being filtered.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    Run only the first part of your command to open the form unfiltered:

    DoCmd.Openform "frmReferrals"

  3. #3
    Join Date
    Nov 2003
    Location
    LONDON
    Posts
    238

    Re: stop form open as filtered.

    Originally posted by billjov
    Im using the following to open a client record after doing a search using search form.

    DoCmd.Openform "frmReferrals", acNormal, , "[DIMAID] = " & lstFound.Column(0)
    Me![lstFound] = ""
    DoCmd.CLOSE acForm, "frmSearchCust"

    After the user clicks on the client in the list box on the search form, the client record opens as filtered. Is there there any way to stop the client form opening from being filtered.
    You could change the form recordsource to an unfiltered record source, you could also turn the forms filter of (Me.FilterOn = False)

  4. #4
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    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
  •