Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

drop down selection

Discussion in 'Information Technology' started by Pam Coleman, Jul 28, 2006.

  1. Pam Coleman

    Pam Coleman
    Expand Collapse
    Guest

    I have a startup form and I want the user to click on a drop down list and
    choose the report they want. Is there a way to have one drop down and show
    the years (2000, 2001, 2002, etc) and they choose the year then click on
    another drop down and click on the report they want. (example:
    Officer-Totals, and Officer-Sex-Race-Citations.) This way they can choose
    the year then the report. This will keep from taking up so much space on the
    form with a button for each report and year. Thanks,
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Pam

    One approach to do this is to have the underlying queries (the reports'
    queries) "look" to the form for the "year" as a criterion, something like:

    Forms!YourStartupFormName!cboYourYearsControlName

    in the criterion row under the "year" field (however you've named that in
    the table) in each of your queries.

    --
    Regards

    Jeff Boyce
    Microsoft Office/Access MVP
    http://mvp.support.microsoft.com/

    Microsoft IT Academy Program Mentor
    http://microsoftitacademy.com/

    Microsoft Registered Partner
    https://partner.microsoft.com/


    "Pam Coleman" <PamColeman@discussions.microsoft.com> wrote in message
    news:F20C0EE9-F83A-4373-A617-DD9BBD5E1905@microsoft.com...
    > I have a startup form and I want the user to click on a drop down list and
    > choose the report they want. Is there a way to have one drop down and

    show
    > the years (2000, 2001, 2002, etc) and they choose the year then click on
    > another drop down and click on the report they want. (example:
    > Officer-Totals, and Officer-Sex-Race-Citations.) This way they can choose
    > the year then the report. This will keep from taking up so much space on

    the
    > form with a button for each report and year. Thanks,
     

Share This Page