How do I set up the access form query button?

2 years ago
Sophia Anderson
2 minutes

To add a query button in an Access form, you can follow these steps:

  1. Open the Access database and select the table or query in the navigation pane where you want to add a query button.
  2. Choose the “Button” tool in the “Form Design” group on the “Create” tab.
  3. Click and drag the mouse on the window to determine the size of the button to be added.
  4. In the “Command Button Wizard” dialog box, choose “Browse records and display in the form.”
  5. Click on the “Next” button.
  6. Enter the name of the button in the “Label for Command Button” text box, for example “Search”.
  7. Click on the “Next” button.
  8. In the “Choose the macro or event procedure to add to the command button” dialog box, select “Macro” or “Event Procedure”, and then click the “Next” button.
  9. If “Macro” is chosen, enter the name of the macro in the “Macro Name” textbox. If “Event Procedure” is selected, write the corresponding VBA code in the event procedure editor.
  10. Click the “done” button.
  11. Adjust the position and size of the buttons on the form to fit your needs.
  12. Save and close the window.

Now, there should be a query button on your Access form that, when clicked by the user, will browse through records and display the query results on the form.

bannerAds