How to assign query to command button of a form

[BizBoy]

Hi,
I do not have any idea about forms.
My post might be wrong. I apologize in advance for the same.

I have a database.
I have written multiple queries for retrieving information from this database.

Now I am trying to design a form, assign a query to command button of the form.
I have bit of VBA experience however I have 0 knowledge about access forms.

Can anyone please guide me about how should I proceed.

 

[xenou]

There are so many hits when googling this that I think you also should just try some searches also.
For instance try googling msaccess run query with command button

 

[ranman256]

select the button , view its properties (F4)
the button has events (events tab of the properties), you want CLICK event,
you can assign a macro from the drop box
in the macro , put in your query OPENQUERY qsMyQuery

so put the query in the macro, save
put the macro in the click event

(a basic Access 'How To' book will tell you all these techniques)

 

[BizBoy]

Thanks for the help ranman. I got stuck when I saw macro option.
I was searching for query option.

Now I understood that I need to put query in macro and assign macro to button.

Have a nice day ahead.

 

[BizBoy]

Thanks a lot for the help xenou. Have a nice day ahead.