Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2002
    Thanked 0 Times in 0 Posts

    Filter gone when form becomes subform. (A2K)

    I build a dynamic filter from criteria entered to a search form.
    I open Form (A) and apply the filter with "DoCmd.OpenForm stDocName, , , stCriteria".
    A button on form (A) opens form ([img]/forums/images/smilies/cool.gif[/img] which includes form (A) as a subform.
    The filter is gone from the SubForm (A), and it shows all records - although form (A) is still open and filtered.

    Does anyone know what is wrong? Thanks!


  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: Filter gone when form becomes subform. (A2K)

    Open Form A as a subform to Form B has nothing to do with it being opened by itself. You could open FormA as a subform on any number of other forms. A subform is not considered an open form, in that it is not in the Forms collection.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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