hi all

I have a recordset that sometimes will pull no data due to changes made to the database tables throughout the useage of the program. My question is this, what is the syntax to handle recordsets when they come up with no info?

i have tried things like this:

VB Code:
  1. If rs("")<>"" then do something

and

VB Code:
  1. IF isNull(rs("")) then do something

how would i word the part concerning the rs on order to satisfy the IF statement?

With both examples i get a
"Item cannot be found in the collection corresponding to the requested name or ordinal."
thanks alot
tibor