R
Rhonda Fischer
Hello,
I am attempting to refresh the parent subform to
bring in effect conditional formatting changing
the colour of my form boxes as soon as a the user
changes a value.
The code I am using is:
-----------------------------------------------------------
Const stProduceChill = "frmProduceChillBack"
If CurrentProject.AllForms(stProduceChill).IsLoaded Then
Forms(stProduceChill).frmProduceChillDetails.Requery
End If
----------------------------------------------------------
The if stmt is entered correctly the error message is
experienced at the second line: Application-defined or
object-defined error.
Any suggestions would be terrific.
Thank you very much
Rhond
I am attempting to refresh the parent subform to
bring in effect conditional formatting changing
the colour of my form boxes as soon as a the user
changes a value.
The code I am using is:
-----------------------------------------------------------
Const stProduceChill = "frmProduceChillBack"
If CurrentProject.AllForms(stProduceChill).IsLoaded Then
Forms(stProduceChill).frmProduceChillDetails.Requery
End If
----------------------------------------------------------
The if stmt is entered correctly the error message is
experienced at the second line: Application-defined or
object-defined error.
Any suggestions would be terrific.
Thank you very much
Rhond