I have three forms.
A, B, C On which all the field names are standard
I have a second form (NOINE) which I would only like to code once.
When A is open and I push a button I want NOINE to open and reference fields on form A
When B is open and I push a button I want NOINE to open and reference fields on form B
How do I pass the form name as a variable so in my text fields on Form Noine I am effectively referencing it like this
[Forms]![FormA]![Standard Field Name Across all forms A, B, C]
[Forms]![Whatever Variable Name I Pass from the button]![Standard Field Name Across all forms A, B, C]
I can always count on you for an answer.
I put the load event in NOINE and I get "Method or data member not found" and me.Text0= is highlighted in the code.
Assuming I get past that then how do I reference the variable in the text fields
[Forms]![FormA]![TextField
Thank you