[AccessD] Opening Recordset Error

Nancy Lytle nancy.lytle at auatac.com
Mon Jun 2 08:56:48 CDT 2003


Can someone see what I am missing here?  I keep getting the error: "Too few
Parameters: Expected 1"

Dim intCounter As Integer
Dim rstFunded As DAO.Recordset
Dim dbFunded As DAO.Database
Dim strFunded As String
strFunded = "SELECT Sum([tblInvoiceFunding.FundsFromCode]) AS Funded"
strFunded = strFunded & " , tblInvoiceFunding.InvoiceID FROM
tblInvoiceFunding GROUP BY tblInvoiceFunding.InvoiceID"
strFunded = strFunded & " HAVING
(((tblInvoiceFunding.InvoiceID)=[Forms]![frmInvoiceDataEntry]![txtINVOICE_ID
]))"
Set dbFunded = CurrentDb()
Set rstFunded = dbFunded.OpenRecordset(strFunded, dbOpenDynaset, dbReadOnly)

TIA,
Nancy L



More information about the AccessD mailing list