function sequence error in ASP

In my application I get the error 'function sequence error' when i try to use RS.MoveFirst . This happens only in one screen but the same doesn't happen in another 2 screens where i am using RS.Movefirst. In all above screens i am coding as

if not rs.eof then
RS.Movefirst
else
---------------
--------------
end if.

Why is that it fails sometimes? Any help will be greatly appreciated.

Honestly, I don't know why you're doing a .MoveFirst

You execute a Query, and you get back a recordset.

then the FIRST thing you do is

If objRst.EOF then
...NO VALUE INSIDE THE RECORDSET...
Else
...YOUPI!!! you have data inside your recordset
End If

Now if you haven't tampered with the recordset BEFORE the If objRst.EOF then there is no reason to do the .MoveFirst since its already a the first record...

Hope this helps!
Sincerely

Vlince