I have a subform that holds a bunch of records for employees. Rather than manually scrolling through I want to be able to click on one and then the subform displays that record.
I tried
- DoCmd.GoToRecord acForm, "frmsubEmployees", acGoTo, lstEmployees.Value
Which works fine if you have the subform open in its own window by itself. But if it is inside "frmAdministration" I get an error:
"Run time error 2489, the object "frmsubEmployees" is not open"
If it matters, the subform inside "frmAdministration" is called "frmsubAdminEdit", then the SourceObject is changed to select the "frmsubEmployees". There is also a few other subforms that show up in "frmsubAdminEdit"