How do I add a text string into a subform control from a button on the main form? I've tried...
Code:Forms!SubFormName!SubFormControl = "MyString"
How do I add a text string into a subform control from a button on the main form? I've tried...
Code:Forms!SubFormName!SubFormControl = "MyString"
Here's a handy reference on the correct syntax:
Forms Refer to Form and Subform properties and controls
Thanks.
I also want to be able to execute a button on the subform using vba. Would you happen to know would syntax would be appropriate there?
If I were going to be calling code from multiple locations, I'd make it a public function. You can call a button with the same syntax but ending with
ButtonName_Click
just as appears in the code for the button.