Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Unanswered: Applying a Filter when opening a Form (from another Form)

    Hi all,
    I currently have a Form setup where you select a Company from a Combo Box and I've created a button that opens up another Form that (supposed) displays additional information about that Company selected.

    My problem is, how do I apply a Filter to the next form so that it recognizes the Company that the user selected in the previous form.
    I'd like the filter to utilize the CompanyID because that's where the relationships pull from.

    Filter on the new form would be [CompanyID]=#

    Any ideas?

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Use the wherecondition argument of OpenForm; more info in VBA Help.

Posting Permissions

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