What result do you see: #Name? #Error? Nothing at all?
If #Name, try solution 1 or 2.
1. Name of subform control.
Open your main form in design view.
Right-click the edge of your subform control, and choose Properties.
On the Other tab of the Properties box, what is the Name of your subform
control?
If the Name is different than "TS1", use the name in place of TS1.
Note that the Name of a subform control can be different than its
SourceObject (the name of the form that gets loaded into the subform
control).
2. Name of calculated control
From the database window, open the subform in design view.
Right-click the calculated control, and choose Properties.
What is the Name of the text box? If it is not "TS2", replace the TS2 in
your expression with the correct name.
If you see #Error:
3. Location of control
Which section is the contorl in? Form Footer is normal. If you have it in
the Page Footer section, move it to the Form Footer (View menu) instead.
4. Error in Calculation
If you still see #Error, post the Control Source of the calculated control.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
DazedConfused said:
For keeping it simple as possable I named the fields TSx
Control Source of TS2
=[TS1].[Form]![TS2]
I have tried every concievable way and finally
figured to try and keep it as simple as I can.
Please explaind how I should cross-post questions to the group.
I will be glad to do so.
Thank You
tina said:
post the calculation or statement you're using in the ControlSource property
of [TS2].
