Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Switchboard to run query
- Thread starter TVTPeggy
- Start date
Hi Peggy...
You will need to modify the properties of the button. You will need to add an Event to the button.
1.Click on properties for the button.
2.Click the Event tab for the button.
3.On the line labeled "On Click", select [Event Procedure]
4. Here you can create a recordset and type in your query.
Another way is to use the command button wizard, he will ask what category and action you want for the button. Select "Miscellaneous" for category and "Run Query" for action. Then select the query you want to run from the dropdown list that appears. The query must already be created for this to work.
Good Luck!!!
You will need to modify the properties of the button. You will need to add an Event to the button.
1.Click on properties for the button.
2.Click the Event tab for the button.
3.On the line labeled "On Click", select [Event Procedure]
4. Here you can create a recordset and type in your query.
Another way is to use the command button wizard, he will ask what category and action you want for the button. Select "Miscellaneous" for category and "Run Query" for action. Then select the query you want to run from the dropdown list that appears. The query must already be created for this to work.
Good Luck!!!
- Thread starter
- #3
- Status
Similar threads
