Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2006
    Posts
    250
    Thanks
    0
    Thanked 0 Times in 0 Posts

    filtering a form based on field in the main form (2003)

    Hello,

    I have a main form where users will be inputing invoices. A user will have to select a company. This will cause the subform to show all program budgets for the selected company. I have added a program field in the main form so the user can select this field, but don't know how to filter the subform to show only the program's budget and not all program budgets. How can I filter the subform? Any help would be great.

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

    Re: filtering a form based on field in the main form (2003)

    Link the subform to the main form by company and program.

Posting Permissions

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