Recent content by KDenham

I've figured out a solution using the FindFirst method on my Recordset which seems much more efficient, too: Dim dB As Database, rst As DAO.Recordset, rstProductList as DAO.Recordset ... Set dB = CurrentdB Set rst = dB.OpenRecordset("tblSuppliers", dbOpenDynaset) ... Do Until rstProductist.EOF...

Thanks, but the SQL query syntax is correct and I use it on other recordsets earlier in the program without any issues.

I am building an application in which I need to execute several queries on the same database table and use the RecordCount of the returned RecordSet to set values in a field of a different table. Below is an excerpt from the code I am using: Dim dB As Database, rst As DAO.Recordset...