G
Guest
My subject line may not accurately describe my problem... I'm using the
following code to evaluate two fields on a form, and then take action based
on the values in those fields. For some reason, on some PC's the code works
perfectly. On others the code does not work, always evaluating a "false"
value in the IF statement and running the "ELSE" portion of the statement -
EXCEPT when in debug mode and stepping through the code. I.e. it doesn't
work on some PC's in "realtime", but does work when stepping through the
code. What is going on? Any thoughts?
Note: the field "SumNonCommitted" is a calculated field, summing values
within the form. This code runs when the field cmb_Month is updated
(AfterUpdate).
If Abs(Me.SumNonCommitted) > 0 And Me.cmb_Month >= #7/1/2004# Then
Me.cmd_ExportExcel.Enabled = False
Me.lbl_ExportExplain.Visible = True
Else
Me.cmd_ExportExcel.Enabled = True
Me.lbl_ExportExplain.Visible = False
End If
following code to evaluate two fields on a form, and then take action based
on the values in those fields. For some reason, on some PC's the code works
perfectly. On others the code does not work, always evaluating a "false"
value in the IF statement and running the "ELSE" portion of the statement -
EXCEPT when in debug mode and stepping through the code. I.e. it doesn't
work on some PC's in "realtime", but does work when stepping through the
code. What is going on? Any thoughts?
Note: the field "SumNonCommitted" is a calculated field, summing values
within the form. This code runs when the field cmb_Month is updated
(AfterUpdate).
If Abs(Me.SumNonCommitted) > 0 And Me.cmb_Month >= #7/1/2004# Then
Me.cmd_ExportExcel.Enabled = False
Me.lbl_ExportExplain.Visible = True
Else
Me.cmd_ExportExcel.Enabled = True
Me.lbl_ExportExplain.Visible = False
End If