Running a make table query

[rohini]

Hey!



How do I run 'make table' queries by clicking on a button in a form?

Thanks

[rohini]

I have to open another form and run around 10 queries from the same command button

[pbaldy]

Look at OpenQuery in either VBA code or macros.

[rohini]

Hey thanks a lot! Used a macro and it works

[A S MANN]

create a macro and add action as Open Query and link to your make table query.
Add the macro to on click event of button to activate it.

[pbaldy]

Happy to help!