Hello,
I currently have many subforms in a form. I have a global varibale created when the item in combo box is selected. After selecting a record from a combo box. I want each of the subform to load with the selected record. I would like to go into each subform under "On Load" to pass the global variable to load that particular subform with the record. Is the right place to do it in? And if so how should that be done.
I would do it with a Openform"doc name",,, 'where case'
But how i have the general form set up, it isn't feasible ,so i just need to have each subform to load with the global variable ID