Update current Record

[holly]

Hi

I have a label which contains an ID now what I want to do is
update the current record if the label contains a value and if not
insert a row....

The code related to the condition is below

If (lblScaleEventID > 0) Or (ObjRSprodidvalues.EOF) Then
        ObjRSprodidvalues.MovePrevious
        ObjRSprodidvalues.Update
     ElseIf (ObjRSprodidvalues.BOF) Then
            Load frmvoidopid
            frmvoidopid.Show vbModal
           Else
            ObjRSprodidvalues.MoveLast
      End If
       lblScaleEventID = ObjRSprodidvalues.Fields(0).Value

I receive an error ' EOF or BOF is true' or record is deleted...

Thanks for your help