HELP Subform Expressions

[Guest]

I am attempting to open a record on another form from an associated record in
a subform of a different form. It works if the WHERE statement on the Macro
is not coming from a subform. I thought I was using the correct expression in
the WHERE statement
[ControlName]=Forms![FormName]![Subform Name]![ControlName]

not sure if I am missing something or if it can work from a subform.

Thanks

 

[Steve Schapel]

Dan,

There is nothing wrong with your syntax. Although some say it is
preferable to do it like this...
[FieldName]=[Forms]![FormName]![Subform Name].[Form]![ControlName]

The first thing I would check is whether the name of the subform control
is different from the name of the form which occupies it. If so, make
sure you have used the name of the subform control in your expression.

Which event on which object is the macro being called from?