Subform/Form Referencing

[NEWER USER]

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!

 

[Al Campagna]

Newer,
Try...
=[parent].[Form]![Cost]

Tested OK for me, with a subform field that got it's vale from City
on my main form.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Stuart McCall]

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.

 

[KARL DEWEY]

Open in design view and edit.

 

[NEWER USER]

Thank you so much. Worked perfectly. Happy Holidays.

Newer,
Try...
=[parent].[Form]![Cost]

Tested OK for me, with a subform field that got it's vale from City
on my main form.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

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!

.

 

[NEWER USER]

I had to use use [Cst]-[Parent].[Form]![Cst] to get it to work. Thanks for
the help.

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.


.