DAO / VB6 code - .MoveFirst statement gives "No Current Record" error
Posted on 2007-08-07
I am using DAO in VB6 code, here's the fragment that is giving the error.
NOZ = datSelectedZValues.Recordset.RecordCount 'the debug window shows that NOZ=1 datSelectedZValues.Recordset.MoveFirst '20070808 - bombs here with "No Current Record" error!
I am getting a "No Current Record" error when the .MoveFirst statement is executed.
How can this error occur when the ..RecordCount statement shows that there is one record?