How to Run a Parameter Query in Access for the Command Button

Written by emmanuelle douglas
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Run a Parameter Query in Access for the Command Button
Create a form to use a command button to run a parameter query in Access. (pregunta image by caironbohemio from Fotolia.com)

Access parameter queries let you prompt your users for additional information. Create the parameter query by adding brackets to the criteria field, with your question inserted inside the brackets. After the parameter query criterion is specified and saved, you can use this parameter query in your forms. Using command buttons is a great way to add interactivity to your forms for your users.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open Access 2007. Select the "Office" button and click "Open." Browse your computer and find the database that contains your parameter query. Select the database and click "Open." The database will open.

  2. 2

    Select the "Create" tab and the "Form Design" button. On the "Design" tab, select the "Button" button. Your mouse cursor will change into a plus sign. Using this new cursor, click and drag to draw a button. After you have drawn the button, release the mouse. The command button wizard will appear.

  3. 3

    Select "Miscellaneous" and "Run Query." Click "Next." Select the parameter query that will assigned to this button. Click on the query and select "Next." Select the "Text" option and type in your query name. You can update this later to a more appropriate query name. Click "Next." Type a name for this command button and click "Finish."

  4. 4

    Save the form by clicking on the "Save" icon on the Quick Access Toolbar. Test the button by clicking on it. You will be prompted with a question from your parameter query. Enter the answer and click "OK." Your parameter query results will be displayed.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.