If i debug this whit step-by-step, i see that if rs is Nil (table of database not have row) the step jump to “Wend” and after jump to End.if (line 10).
The line 9 is not execute. Why?
Can you help me?
thanks
The RecordSet will not be nil if the database does not have the row. RecordSet will only be nil if there is an issue with your SQL statement. If the database does not have the row you are looking for the RecordSet.RecordCount will be 0.
My untested guess is that rs in your code is not actually nil.