error when displayed as subform, but not when displayed as standal

[Xero]

hello,

i have a field on a form which calculates and displays the number of records
(using the 'count' expression).

when I open the form as a standalone form, the field displays correctly; but
when I open the form as a subform of another form, it says #error.

what would cause such a problem?

thanks.

Jeff

 

[John W. Vinson]

hello,

i have a field on a form which calculates and displays the number of records
(using the 'count' expression).

when I open the form as a standalone form, the field displays correctly; but
when I open the form as a subform of another form, it says #error.

what would cause such a problem?

An error in the calculation expression... which I cannot see from here. Care
to post it so someone could help?

 

[Bob Quintal]

hello,

i have a field on a form which calculates and displays the number
of records (using the 'count' expression).

when I open the form as a standalone form, the field displays
correctly; but when I open the form as a subform of another form,
it says #error.

what would cause such a problem?

thanks.

Jeff

You have some reference to the form's name in the code.
When you open a form in a subform control on another form, it loses
it's name and becomes known as
Forms![MainForm]![subformcontrolName].Form![formname]