Welcome to SPN

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

Sign Up Now!

drop down list

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

Tags:
  1. Pam Coleman

    Pam Coleman
    Expand Collapse
    Guest

    on a startup form I want to create a button that will let you choose from a
    drop down list and when you click on that choice, it will run the query?

    I have a list of departments (15), Information & Techonology, Administrative
    Services - Fiscal (example) (long names) and if I have a parmeter set up to
    Enter the name and part of it is left out or misspelled it will not run. I
    just want the user to click on a drop down arrow and choose the department
    and then the query will run. Thanks
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Thu, 29 Jun 2006 09:22:02 -0700, Pam Coleman wrote:

    > on a startup form I want to create a button that will let you choose from a
    > drop down list and when you click on that choice, it will run the query?
    >
    > I have a list of departments (15), Information & Techonology, Administrative
    > Services - Fiscal (example) (long names) and if I have a parmeter set up to
    > Enter the name and part of it is left out or misspelled it will not run. I
    > just want the user to click on a drop down arrow and choose the department
    > and then the query will run. Thanks



    Add a combo box to your form that will show the Department field.
    Make sure the Combo Box Bound Column is the
    same DataType as the Department field.

    Add a command button.

    Code the button's Click event:
    DoCmd.OpenQuery "QueryName"
    DoCmd.Close acForm, Me.Name

    Name this form "ParamForm"

    Code the Query Department field criteria line:
    forms!ParamForm!ComboBoxName

    Open the form.
    Find the Department in the combo box.
    Click the command button.

    The query will display just those records selected.
    The Form will close.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page