Function Module and [Forms]!

[Dalan]

This is a bit strange, but I seem to be unable to extract a Function
result and have it to post into a control on a form in Access 97. I
have done something similar in the past and it has worked fine. What
could be different?

The Function returns the results of totalling a list of items in a
subform which is linked to a main form. The correct total appears on
the subform control by using =GetTotal([IDSales]), field name
TotalSales. So in a field on the main form I'm using a control source
=[Forms]![frmMain]![sfrmSales]![TotalSales] which should show the
total, but it does not - instead #Name? Yes, I have double checked the
spelling.

Does anyone have any ideas as to how to make this work? Thanks for
your time and assistance. Dalan

[Allen Browne]

Try:
=[Forms]![frmMain]![sfrmSales].[Form]![TotalSales]
If the ".Form" bit needs explaining, see:
Referring to Controls on a Subform
at:
http://members.iinet.net.au/~allenbrowne/casu-04.html

If that still does not work:
1. Open the main form in design view.
2. Right-click the edge of the subform control, and choose Properties.
3. Check the Name property.
The Name of a subform control may be different to the name of the form it
contains (its SourceObject).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...

This is a bit strange, but I seem to be unable to extract a Function
result and have it to post into a control on a form in Access 97. I
have done something similar in the past and it has worked fine. What
could be different?

The Function returns the results of totalling a list of items in a
subform which is linked to a main form. The correct total appears on
the subform control by using =GetTotal([IDSales]), field name
TotalSales. So in a field on the main form I'm using a control source
=[Forms]![frmMain]![sfrmSales]![TotalSales] which should show the
total, but it does not - instead #Name? Yes, I have double checked the
spelling.

Does anyone have any ideas as to how to make this work? Thanks for
your time and assistance. Dalan