Forum Discussion

Tony2021

Iron Contributor

Jul 24, 2023

Solved

parent and subform calling

Hello Experts, I have a bound parent form (frmPPA) I also have a subform (subfrmPPA) I have an unbound field on frmPPA and I want to populate it with the value from subfrmPPA.ProjIDfk (the name of...

access

Harun24HR
Jul 24, 2023
Tony2021 This simple expression should work. Try it please and let us know.
=[subfrmPPA].[Form]![txtIDPrjDet]

Gustav_Brock

Iron Contributor

Jul 25, 2023

Tony2021 I think what you are after as ControlSource is:

=[subfrmPPA].[Form]![ProjIDfk]
- or:
=[subfrmPPA].[Form]![txtProjIDfk]

Please note, that subfrmPPA must be the name of the subform control which may differ from the name of the subform itself.

Tony2021
Iron Contributor
Jul 25, 2023
what a pain that was. I spent 3 hours on this.
Tony2021
Iron Contributor
Jul 25, 2023
I think my form was corrupted. I created another form and the unbound fields then populated with the data. thanks guys. Appreciate it. Both answers worked.