How do you run a query by clicking on a button?

[sgkim151]

Hi, this must be a very basic question, but I can't find a way to do it. So here it goes.

I'm wondering how you run a query by clicking on a command button on a form. You can use a Command Button Wizard, which lets you choose an option and automatically connects the button to some sort of a method that runs the given query. But I'd like to do it manually.



How do you do it? What method or a group of VBA codes do you need to put in which part?

[orange]

Have you considered using the wizard, then analyze the code created by the wizard? That should give you some insight on the steps involved to do it manually.


Good luck.

[sgkim151]

I've figured that out. I had zero knowledge on macros and embedded macros, which I've just taught myself. Thanks for the reply!