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:

enter image description here

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:

  1. make sure there no special characters in forms' names
  2. compact , repair
  3. create new blank project , import of database blank project

Comments

Popular posts from this blog

apache - PHP Soap issue while content length is larger -

asynchronous - Python asyncio task got bad yield -

javascript - Complete OpenIDConnect auth when requesting via Ajax -