Form 'OnCurrent' Event not firing properly, but does when stepping through it??

[BlueIshDan]

I don't know but this is a shot in the dark.

Maybe something to do with the case sensitivity during runtime of your

    If Me.txtAccountsStatus = "Account on Stop" Then
        Me.cmdProceed.Visible = False
        MsgBox "Account is on stop" & Chr(13) & "You can view orders but can not place orders for this customer.", vbInformation
    Else
        If Me.txtNet <> 0 Then
            If Me.txtNet <> Forms![COLOR="Red"]frmorderentry[/COLOR]![tblAllocation_subform].Form.txtSumAmount Then
                Me.cmdProceed.Visible = False
            Else
                Me.cmdProceed.Visible = True
            End If
        Else
            Me.cmdProceed.Visible = True
        End If
    End If

frmOrderEntry

 

[BlueIshDan]

Also what is the difference between:

Me.txtNet <> Forms!frmorderentry![tblAllocation_subform].Form.txtSumAmount

and

Me.txtNet <> Me.tblAllocation_subform.Form.txtSumAmount
[/CODE[

 

[JeffBarker]

Also what is the difference between:

Me.txtNet <> Forms!frmorderentry![tblAllocation_subform].Form.txtSumAmount

and

Me.txtNet <> Me.tblAllocation_subform.Form.txtSumAmount
[/CODE[[/QUOTE]

Hi Dan,

Thanks for your suggestions regards Case Sensitivity, once I'm able to access the database again I'll have a play with that.

Regards the above though, there's no difference, save for the latter not having the 'Forms!frmOrderEntry!' prefix...why's that? I'm guessing it's something I've missed somewhere...

 

[vbaInet]

Sample form attached!

Look forward to hearing what you guys are able to come up with!!

Not sure how you expect us to test this without some data and steps to reproduce the problem.