While you might see DoCmd.RunSQL in older tutorials, it is generally discouraged because:
If your code crashes before you turn warnings back on, your Access environment will stay "silent" for everything. Access Vb Code For Calling Queries
This method is "silent" and won't trigger the "You are about to append X rows" pop-ups. 3. Passing Parameters to a Query While you might see DoCmd
To call queries in Access VBA, you generally choose between opening a visual result for the user or executing a hidden data change. ⚡ Quick Summary: Which Method to Use? Best Method to the user DoCmd.OpenQuery Opens the query in a datasheet view. Run action (Update/Delete) CurrentDb.Execute Silent, faster, and allows better error handling. Pull data into code OpenRecordset Allows you to loop through rows and read values. 📂 1. Opening a Query for Users Passing Parameters to a Query To call queries