Tina..Still there?..Anyone figured this out?...

message from DazedConfused on 17 May 2004
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" <nospam@address.com> wrote in message
does the calculated control [TS1] in the subform work?
 
Allen Browne replied to DazedConfused on 18 May 2004
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.
 

Archived message: Tina..Still there?..Anyone figured this out?... (MS Access)