ADDING BUTTONS TO FORMS

Im just posting this on the blog because i think this is important and i will be constantly referring ot it so i thought it would be good if it was on my blog :)

Buttons can be used to control database functions in this case we will create a button to open a query. Open a database that has a query in it then;

1. Create a form using design view.
2. Click on the Control Wizard tool.
3. Click the Command Button tool.
4. Click on the form where you want the button to appear.
5. The window shown below will appear. Select Miscellaneous and Run Query as shown. Click next.
6. Select the appropriate query (you have to have made a query before hand). Click next.
7. Label the button by selecting the text option. Click next.
8. Name the button command then click finish.
9. While still in design view create labels for your form using the Aa tool.
10. You can colour the background by simply right clicking on it and choosing Fill/Back Colour.
11. Resize and position the queries as required then click save to have them permanently appear in that position each time the button is clicked.