Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Irvine, California, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ComboBoxes on Form to filter a Report (Access 97)

    I have two combo boxes on a form which will be used as criteria for a report. How do I store the value selected by the user in the combo box, and then use in a query to filter my report?

    Thank you,
    Kim

  2. #2
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ComboBoxes on Form to filter a Report (Access 97)

    Set source of combobox to

    [query]![queryname]![fieldname]

    Search MSKB for filter by form

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ComboBoxes on Form to filter a Report (Access 97)

    Unless you want to store the details for printing out later, it is not so much a case of storing the value as having the query checking the values when it is run.
    In the criteria field of the Query grid use the builder to get the value from the combo box on the form, some thing like
    [Forms]![frmReportFilter]![cboLineName]

    HTH

    Peter

Posting Permissions

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