=> ErrMsg: Application-defined or object-defined error

  • Thread starter Thread starter Rhonda Fischer
  • Start date Start date
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
 
Rhonda said:
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.


Try this:

Forms(stProduceChill).frmProduceChillDetails.FORM.Requery
 
Back
Top