THank you very much pbaldy, going to update and try today, just another one, that's bugging me as i cant see s problem ?
I am getting a runtime error 3131 sytax error in FROM clause from this one
strCustName is set to string and InvNo is set to integer and the record does exist
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 & "'" & " & InvoiceNumber = " & InvNo)