L
Larry Kahm
I have a form called frmArticles that has a subform called sfrmArticleTasks
that is in a container called isfrmArticleTasks. This way, I can keep
better track of the subform name versus the container. The forms are
linked via the ArticleID.
In frmArticles Open event I test to see the mode in which to open the form:
Add, Edit, or Browse. The first two use a table as the main form's
recordsource, the latter uses a query.
In Add or Edit mode, I can reference the controls on the subform with the
following construct:
Me!isfrmArticleTasks.Form![controlname].property = value
When I try the same thing in Browse mode, I get error 2455 - you entered an
expression that has an invalid reference to the property Form/Report.
I am stumped. What is it about the table versus query as RecordSource that
is different? How can I manipulate the controls on the subform in Browse
mode?
Thanks!
Larry
that is in a container called isfrmArticleTasks. This way, I can keep
better track of the subform name versus the container. The forms are
linked via the ArticleID.
In frmArticles Open event I test to see the mode in which to open the form:
Add, Edit, or Browse. The first two use a table as the main form's
recordsource, the latter uses a query.
In Add or Edit mode, I can reference the controls on the subform with the
following construct:
Me!isfrmArticleTasks.Form![controlname].property = value
When I try the same thing in Browse mode, I get error 2455 - you entered an
expression that has an invalid reference to the property Form/Report.
I am stumped. What is it about the table versus query as RecordSource that
is different? How can I manipulate the controls on the subform in Browse
mode?
Thanks!
Larry