C
Clay_LMCO
I have some very extensive VBA code using Access forms for the UI. While
migrating from Access 2003 to Access 2007 I have encountered a problem with
the "visibility" of subform controls and their properties in my VBA code.
One of two things happens when the problem occurs:
1. The code behaves as if I have put in a "On Error Resume Next" statement
and ignores any problems.
2. I get the following error - "The expression you enetered refers to an
object that is closed or doesn't exist."
The problem appears to be triggered after I change the RecordSource property
of the subform. I have written code that will search for the control objects
starting with the Application.Forms property and searching down through the
subforms to get to the controls, but this is very cumbersome and performance
is slow.
Has anyone encountered this and found a fix?
Thanks.
migrating from Access 2003 to Access 2007 I have encountered a problem with
the "visibility" of subform controls and their properties in my VBA code.
One of two things happens when the problem occurs:
1. The code behaves as if I have put in a "On Error Resume Next" statement
and ignores any problems.
2. I get the following error - "The expression you enetered refers to an
object that is closed or doesn't exist."
The problem appears to be triggered after I change the RecordSource property
of the subform. I have written code that will search for the control objects
starting with the Application.Forms property and searching down through the
subforms to get to the controls, but this is very cumbersome and performance
is slow.
Has anyone encountered this and found a fix?
Thanks.