vba - Method 'Parent' of object failed -
i have ms access 2013 , i'm trying make search form populates other details when row inside subform selected. figured out how row selected, , column, need pass information parent form can populate other things on form.
so on form's subform, made on click event:
option compare database private sub form_click() msgbox(me.name) ' returns p_pat subform msgbox(me.parent.name) ' says 'parent' failed
but can never find parent. tried on few other events results same. access form looks this:
the highlighted subform 1 i'm trying work with, , want call parent parent can populate other child subform (the 1 below highlighted form).
i feel slammed brick wall shouldn't there , pride hurts.
how parent?
i know can set record id selected global variable, have no way of triggering update event other subform.
any or advice?
there doesn't there @ wrong code. research there seem 3 possible solutions have found far:
- make sure there no special characters in forms' names
- compact , repair
- create new blank project , import of database blank project
Comments
Post a Comment