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

    Parameter Query within form dropdown (Access 2002/2003)

    Hello,

    I am having a problem getting a parameter type query to work within an existing form-driven combo box query (that drives a report) that is used to choose a Company Name , then Machaine #, then I want to have a Start Date and an End date as a parameter for the report.

    In the attached dbase the frmMachineNo is the form I am having dificulty with. I can get the Start date but am not sure how to parameter the End date.
    I am probably trying to tie too much into the frm MachineNo frm.
    Any help would be appreciated.

    Also, I had to delete several forms and queries to get the file zip down small enough.

    Thanks,

    Bart Putnam

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

    Re: Parameter Query within form dropdown (Access 2002/2003)

    In the query, set the criteria for the date field to

    Between [Forms]![frmMachineNo]![cboMachineNoStartDate] And [Forms]![frmMachineNo]![cboMachineNoEndDate]

Posting Permissions

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