Welcome to SPN

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

Sign Up Now!

MS Access Query Prompting

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

  1. ShrinePP92

    ShrinePP92
    Expand Collapse
    Guest

    I have a query Prompt come up asking "What Department?" I also have a list of
    Departments as a Table. How do I get the Prompt to include a "Drop Down
    List" when I prompt. Presently, I have to type in one of the 52 departments
    and would like a dropdown.
     
  2. Loading...


  3. freakazeud

    freakazeud
    Expand Collapse
    Guest

    Hi,
    place a combobox control on a custom form. This will be the control which
    holds all possible options (bound to your table) which you can then reference
    in the query criteria of the appropriate field with:

    [Forms]![YourForm]![YourControl]

    The form has to be open at query run so the selected value can be used as
    the parameter in the query.
    HTH
    Good luck
    --
    Oliver
    Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
    http://www.oli-s.de


    "ShrinePP92" wrote:

    > I have a query Prompt come up asking "What Department?" I also have a list of
    > Departments as a Table. How do I get the Prompt to include a "Drop Down
    > List" when I prompt. Presently, I have to type in one of the 52 departments
    > and would like a dropdown.
     
  4. schasteen

    schasteen
    Expand Collapse
    Guest

    You will have to create a form with a combo box and set the row source
    property to your table. Then in your query where you have the criteria [What
    Department?] change it to Forms![YourFormName]![YourComboBoxName]. You can
    also set the after update event of the combo box to open your query.

    "ShrinePP92" wrote:

    > I have a query Prompt come up asking "What Department?" I also have a list of
    > Departments as a Table. How do I get the Prompt to include a "Drop Down
    > List" when I prompt. Presently, I have to type in one of the 52 departments
    > and would like a dropdown.
     

Share This Page