Hi all,
We've just upgraded to Office 365 and I've had a puzzling error come up in one of my forms. There's a part of Form_Current routine that display an error only when a the form is first opened:
Private Sub Form_Current()
If Me.NewRecord = False Then
Me.cmbCustomer.SetFocus
Call ValidateForm(False, False)
If Me.Warn.Value = True Then
Me.Warn_Msg.Visible = True
MsgBox Me.Warn_Msg.Value, vbApplicationModal, "Customer warning"
Else
Me.Warn_Msg.Visible = False
End If
If Me!frmInvoices!txtTotalLice <> 0 Then
Me.MIL_Lic.Value = True <<<< ERROR 2448
Else
Me.MIL_Lic.Value = False <<<< ERROR 2448
End If
End If
End Sub
"You cannot assign a value to this object"
MIL_Lic is just a tick box, so is only True/False or -1/0 and I've tried both formats
Strangely enough, it only happen when the form first loads up - every other trigger for Form_Current does not display an error.
Does access do something different when Current runs for the first time?
It was working fine under access 2007
Help!
We've just upgraded to Office 365 and I've had a puzzling error come up in one of my forms. There's a part of Form_Current routine that display an error only when a the form is first opened:
Private Sub Form_Current()
If Me.NewRecord = False Then
Me.cmbCustomer.SetFocus
Call ValidateForm(False, False)
If Me.Warn.Value = True Then
Me.Warn_Msg.Visible = True
MsgBox Me.Warn_Msg.Value, vbApplicationModal, "Customer warning"
Else
Me.Warn_Msg.Visible = False
End If
If Me!frmInvoices!txtTotalLice <> 0 Then
Me.MIL_Lic.Value = True <<<< ERROR 2448
Else
Me.MIL_Lic.Value = False <<<< ERROR 2448
End If
End If
End Sub
"You cannot assign a value to this object"
MIL_Lic is just a tick box, so is only True/False or -1/0 and I've tried both formats
Strangely enough, it only happen when the form first loads up - every other trigger for Form_Current does not display an error.
Does access do something different when Current runs for the first time?
It was working fine under access 2007
Help!