Switchboard to run query

[TVTPeggy]

I am doing a switchboard with an unbound form using the button key off the tool box. This opens forms fine but I want a button to run a query and I don't know how that works.

Thank you,
Peggy

 

[mibeach7]

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!!!

 

[TVTPeggy]

I feel so utterly stupid. I have gone thru and thru the wizard but NEVER clicked on the Miscellaneous Button. That is just what I needed. Thank you so much.

Peggy

P.S. The other way you mentioned looked way scarey!