Hi, I am VBA newbie and I can't figure out what is wrong with my code, it give me the "too few parameters expected 3" error all the time...
Here is my stupid code...
Code:Dim db As DAO.Database Dim rst As DAO.Recordset Dim result As DAO.Recordset Dim str1 As String Dim str2 As String Set db = CurrentDb str1 = "SELECT * FROM Query1;" str2 = "SELECT * FROM Query2;" Set rst = db.OpenRecordset(str1, dbOpenSnapshot) Set result = db.OpenRecordset(str2, dbOpenDynaset)