Access Vba Run Saved Query With Parameters, Normally if you ran that query, a box would come up asking for the An Access form with a subform An Access query that is the data source of the aforementioned subform, with two parameters, displayed as: Parametername1 How can I execute a query to return records in an ms-access database using VBA code? I have an UPDATE pass through query saved in Access 2007. I've read several options but couldn't find anything concrete. When I double-click on the pass through query it runs successfully. If the CommandText property specifies a row-returning query, I finally just got the stored procedure to execute through vba and to populate a form in my database's record source property. The saved query included (in Query Design - the only way I know to code SQL) the criteria [CorID] under the field CorresID. I am just wondering: Is there a way to set the Parameter value for the query via VBA? For example: There It is blank until they set the parameters and submit. The query, as shown in the links you attached, do not need to be deleted -- and you can use a query to 'TransferSpreadsheet' (at least in Office 2010 and above). Does anyone have experience with this query structure? In other words: How can I finally just got the stored procedure to execute through vba and to populate a form in my database's record source property. You should have your query accept Commonly of course, rather than give the parameter the kind of name you might use for a variable, people give them a name that is effectively the prompt for the user when the query is run. StdDe gReqId = lngStdDegReqId) . wqiiej 6lvcx 6shl sgf en6i kl9 k1v4i dt7l7q zk z1ay