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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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.

sundaytwins said:
Previously, i had a Access database in which I used a subform to display
Click to expand...
the results of a filter in a linked form.
When I then clicked the name of the desired record (or any other field),
Click to expand...
the result was put back in the form by means of a
=[Form]![Subform name]![Focussed field name] type of construction. This
Click to expand...
worked fine in Access 2000, but
 
Back
Top