Error 2427: You entered an expression that has no value??? (1 Viewer)

[ForcedToUseIt]

Hi, I have a form that has been working for me without problems for a long time and now it has stopped working! When I try to open it, this pops up:

Run-time error '2427':

You entered an expression that has no value.

The code that generates the error is in the Form_Current event and this code is at the top.
At first it happend on this piece of code (line 1):

If Len(Form_sfrmPurchOrder.PurchNo) > 0 And Len(Form_sfrmContractOrder.ContractNo) > 0 Then
  Form_frmProcurementProducts.labPOCOwarning.Visible = True
ElseIf Len(Form_sfrmPurchOrder_ForBidders.PurchNo) > 0 And Len(Form_sfrmContractOrder.ContractNo) > 0 Then
  Form_frmProcurementProducts.labPOCOwarning.Visible = True
Else
  Form_frmProcurementProducts.labPOCOwarning.Visible = False
End If

Then I removed the above code and then the same error occured just in the next line(line 2):

With Me.sfrmContractOrder
    If .Form!ContractConfirm = True Then
        .Form!ContractDate.Enabled = False
    Else
        .Form!ContractDate.Enabled = True
    End If
    If .Form!LoAConfirm = True Then
        .Form!LoADate.Enabled = False
    Else
        .Form!LoADate.Enabled = True
    End If
End With

Im not quite sure what the problem is but perhaps it has something to do with the fact that the first record in my form is almost completely empty (no data in the subforms) and that seems to be the problem.
If you have any suggestions they would be greatly appreciated.

Thanks,

 

[ForcedToUseIt]

This form does not work at all now. I get this same error even if i remove the whole form_current event. then the problem occurs just somewere else when i move between records.
This problem occurred after I moved the whole database (Sql server 2000 backend Access 2003 frontend(.mdb)) to a new server. Everything works fine on the old server.
Does anyone have any ideas on what could be the problem???
Im completely lost.
Perhaps this question should be in the sql server part of the forum.

Thanks