Text box problem

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

Guest

Dear all,

When I set a text box in main form with formula : [Invoice detail]![Total]
to show the total value of the subform.
It only shows the value in access 2000, but it's blank in access 2003.

Can anyone tell me why?
Thanks a lot
 
Thank you Allen.

Allen Browne said:
You have a subform named "Invoice detail", and on that subform is a text box
named "Total". In the main form, you want to display the total. Try a
Control Source of:
=[Invoice detail].[Form]![Total]

That should work in all versions. If the ".Form" bit is new, see:
http://members.iinet.net.au/~allenbrowne/casu-04.html

If that does not solve the problem, try unchecking the Name AutoCorrect
boxes under:
Tools | Options | General
Explanation:
http://members.iinet.net.au/~allenbrowne/bug-03.html

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

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

Daniel said:
Dear all,

When I set a text box in main form with formula : [Invoice detail]![Total]
to show the total value of the subform.
It only shows the value in access 2000, but it's blank in access 2003.

Can anyone tell me why?
Thanks a lot
Click to expand...
Click to expand...
 
Back
Top