IIF vs RecordSet issue

[wquatan]

Let's assume we have :

- a recordset (rs) from a query returning no records
- a wrkField containing "A"

The following statement

wrkTarget = iif(rs.EOF, "NO", rs.[Field])

works correctly, wrkTarget = "NO" in the example

The statement

wrkTarget = iif(rs.EOF, "NO", iif(wrkField = "A", "YES", rs.[Field]))

gives an error "No Current record" dispite the fact it should never get to rs.[Field]

Does someone knows what's happening and how to bypass (I know IF ... THEN ... ELSE, but want to keep going with IIF)

Thanks

[NeoPa]

WQuatan:
dispite the fact it should never get to rs.[Field]

That statement is incorrect. It is behaving exactly as the documentation says it does. All parameters are evaluated before the call to the IIf() function is processed. They must be - to pass the values as parameters. Essentially, the error occurs before IIf() even starts to execute.

Does that help?