Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SubForm Filter (2003)

    Can anyone tell me what the format is for interrogating the sub form filter.

    I have a form where the users will use the Filter buttons to obtain records in the sub form.
    Once they have the records they need they will run a report that should only print their selected records.

    I want to interrogate the sub form filter and build a filter into the sub report.

    Form Name = frm_LS_Item
    subForm Name = frm_Certs_sbfrm

    Thank you
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

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

    Re: SubForm Filter (2003)

    You can use Forms!frm_LS_Item!frm_Certs_sbfrm.Form.Filter

    Note: you must use the name of the subform as a control on the main form. This is not necessarily the same as the name of the subform in the database window. Open the main form in design view and click once on the subform to see its name in the Properties window.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SubForm Filter (2003)

    Thank you Hans.
    I was forgetting the .Form
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

Posting Permissions

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