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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xero - 18 Feb 2008 23:11 GMT

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

Reply to this Message

John W. Vinson - 19 Feb 2008 00:20 GMT

>hello,
>
[quoted text clipped - 5 lines]
>
>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?

Signature

John W. Vinson [MVP]

Reply to this Message

Bob Quintal - 19 Feb 2008 22:56 GMT

> hello,
>
[quoted text clipped - 10 lines]
>
> 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]

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message