I am setting a variable to a recordset. The tables are linked to SQL so I must use the dbSeeChanges parameter. I keep getting error message 3061 Too Few Parameters. Expected one.
Set rs = CurrentDb.OpenRecordset("Select * from tjnc_Batches_Transactions Where BatchID = " & Me!BatchID & " and FundID = " & Me!cboFundID & " and Me!CalcInDollars = True", dbOpenDynaset, dbSeeChanges)