Results 1 to 2 of 2
  • Thread Tools
  1. Star Lounger
    Join Date
    Feb 2002
    Posts
    74
    Thanks
    0
    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!

    Randy

  2. Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,306
    Thanks
    1
    Thanked 11 Times in 11 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
  •