if rs.eof or rs.bof then
.....your stuff if its not rs.eof or if rs exists
"Adam Knight" <aj.knightoptusnet.com.au> wrote in message
news:eBgcKRnWDHA.2328TK2MSFTNGP12.phx.gbl...object> The property statement below will aim to identify whether a recordset> (rs) exists, and is not eof; and set its value the the recordset data.
> Is this possible. Any suggestions on how to do this..would be appreciated.
> Public Property Value (str)
> If ??? Then Element_Data = rs(str)
> End Property