Calling a query from vba code behind a button

[tazbrown66]

Could someone please tell me how do I call/run a query using VBA coded behind a button on a form.

When the button is clicked, I want to run two append queries and then display a table that these append queries populate. Any ideas?

 

[drctx]

this would do it:

DoCmd.SetWarnings False
DoCmd.OpenQuery "QueryName1"
DoCmd.OpenQuery "QueryName2"
DoCmd.SetWarnings True
DoCmd.OpenTable "TableName

 

[tazbrown66]

Thanks alot