cnn.Execute CommandText:="[QueryName]", _
              RecordsAffected:=vbNullString, _
              Options:=adCmdStoredProc Or adExecuteNoRecords

has been used instead of "DoCmd.RunSQL".

The Query was changed but executing the VBA code still uses the previous
query.  I obviously do not understand Stored Procedures because when
anything about them is read it never seems to pertain to anything within an
Access database.

Can someone help with how to update the "StoredProcedure" or a better method
of executing a Query from VBA.  DAO is not referenced since ADO is being
used.