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:
Other People Are Reading
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.
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.
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."
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for