"Tetsuya Oguma" wrote:

Hi all,

I loop through some cells and each cell value is part of SQL string that I
query database with.

When it loops a second time on IIF clause, a Run-time error of 3021 'Either
BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current reocrd."
"Tetsuya Oguma" wrote:

Hi Tetsuya

You need to move to the first record in the recordset.

To test and set the pointer you can use somthing
like the following,

If rsCParty.BOF And rs.RecordCount 0 Then
rsCParty.MoveFirst
or:
rsCParty.MoveFirst "this can fail if recordset is empty"

Good Luck
TK