hi:)

    Dim rspara As New ADODB.Recordset
Me.Frame2.Enabled = True
Me.cb_exit.Enabled = True
Me.start.Enabled = True
Me.cb_Options.Enabled = True
Me.cb_print.Enabled = True
rspara.Open "select * from Parameter_Setting where set_code=5 and status=1", dbconn, adOpenKeyset, adLockReadOnly
If rspara!status = 0 Then
Me.Order_Card.Enabled = False
Else
Me.Order_Card.Enabled = True
End If
Me.Flex.Enabled = True
Me.cb_Sel_Match.Enabled = True
Me.cb_cut_order.Enabled = True
Me.From_Date.Enabled = True
Me.To_Date.Enabled = True
rspara.Close


When I run this function I face an error message "3021" with the following statement:

"Either BOF or EOF is true, or the current record has been deleted. Requested operation requires a current record."

I am not sure what I am doing wrong here.

Please help.

Thanks in advance ...

hi there..

there is anything wrong with this, the only thing that is happening is that your query doesn't return a row ;)

try that query in a query analizer to see if that return something...

to avoid this problem test for both .eof and .bof before trying to read an actual value.

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========