Reference to a focussed item in subform doesn't seem to work in Access 2003 anymore

[sundaytwins]

Previously, i had a Access database in which I used a subform to display the results of a filter in a linked form
When I then clicked the name of the desired record (or any other field), the result was put back in the form by means of
=[Form]![Subform name]![Focussed field name] type of construction. This worked fine in Access 2000, bu
doesn't seem to work anymore in Access 2003. Anyone has a clue on how to solve this
Or maybe a better rephrasing: What do I do wrong ?

 

[Allen Browne]

Subforms are not part of the Forms collection, so you cannot refer to them
as:
Forms!...
You can (and should) use the ".Form" bit after the subform control name:
=[Form]![Subform name].[Form]![Focussed field name]
For an explanation, see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

If that does not solve the problem, check the Name of the subform control:
- Open your main form in design view.
- Right-click the edge of the subform control, and choose Properties.
- On the Other tab of the Properties box, what is the Name of the Control?
The name can be different from the name of the form it contains (its
SourceObject).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Previously, i had a Access database in which I used a subform to display

the results of a filter in a linked form.

When I then clicked the name of the desired record (or any other field),

the result was put back in the form by means of a

=[Form]![Subform name]![Focussed field name] type of construction. This

worked fine in Access 2000, but

 

[sundaytwins]

Thanks Allen, This was the 'missing' link to the solution.

Many thanks!!

Sundaytwins.

 

[support]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting