Prev: Refresh Subform Current Record?
Next: TransferDatabase method
From: NEWER USER on 3 Dec 2009 13:39
I had to use use [Cst]-[Parent].[Form]![Cst] to get it to work. Thanks for
the help.

"Stuart McCall" wrote:

> "NEWER USER" <NEWERUSER(a)discussions.microsoft.com> wrote in message
> news:6842A325-7A3A-4399-92CE-0F119BF03F74(a)microsoft.com...
> >I have a Subform that resides on numerous Forms. I have a calculated field
> > on the Subform that references a field on the Form.
> >
> > [Cost] - Forms.FormName.[Cost]
> >
> > As I place the same Subform on other Forms, the reference is now incorrect
> > because the Form Name has changed. What coding would I use to replace
> > Forms.FormName so the subform will reference the Current Form and display
> > values correctly? Any help appreciated!
>
> Me.Parent.Form.ControlName
>
> is what you need.
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Refresh Subform Current Record?
Next: TransferDatabase method