Hi Guy's, i am getting a runtime error 3061 too few parameters. expected 1.
rs is set as Dao.Recordset
strCustName is String
InvNo is Integer and record exists ??
Kindest
Code:
Set rs = CurrentDb.OpenRecordset("SELECT tblInvoices.tblInvoiceNumber, tblInvoices.InvoiceDate," _
& "tblInvoices.Customer, tblInvoices.Add1, tblInvoices.Add2, tblInvoices.Town, tblInvoices.PostCode," _
& "tblInvoices.InvoiceDetails, tblInvoices.Amount FROM tblInvoices WHERE Customer = '" & strCustName & "'" & " And InvoiceNumber = " & InvNo)