Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Location
    Midland, Michigan, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form/Report drop down (Access 2003)

    Hello,
    I have a problem similar to one I had before.
    I have a report driven by a form. The form asks for Company Name, then is supposed to list dates associated with the chosen company.
    I cant get the combo box to populate with the record relevant to the company name.

    This is already being done with Company name and Machine No., but i can't get the date combo box to work.

    The Form is frmCompanyDate which fires the rptCompanyDate, which is pulled from qryCompanyDate.
    Could it be that the'Date' field in Analysis table is a Date/Time format?

    Bart Putnam

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

    Re: Form/Report drop down (Access 2003)

    You have put the criteria in qryDate under the Date field, but it should be under the Company Name field instead. (You want to display all dates for the selected Company Name)

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Form/Report drop down (Access 2003)

    In qryDate you have the criteria in the wrong column.

    The form is providing a company name, but you have put it in the Date column.
    Regards
    John



  4. #4
    New Lounger
    Join Date
    Apr 2004
    Location
    Midland, Michigan, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form/Report drop down (Access 2003)

    Thanks Guys!
    I knew it would be something simple.

Posting Permissions

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