Open a form using a link to a Previous Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry if this is a little bit of a noob questions, I have a Form (frm.a)
that has two subform (datasheet view, sub.a, sub.b). I want to open a
additional form based on the active line in sub.a or sub.b. as it links to
that data.

When I insert the command botton on the form it asks for the link for the
data, it only displays the frm.a controls, and the form I am opening
controls. Is there a way to get it to link to the sub form controls? Or am
I just going about this the wrong way?

Thanks
 
hi,

Mr.wizzard said:
When I insert the command botton on the form it asks for the link for the
data, it only displays the frm.a controls, and the form I am opening
controls. Is there a way to get it to link to the sub form controls?
Click to expand...
You can access your subforms from your main form using the subform
control, e.g.:

MsgBox subformctrl.Form![ID]

'subformctrl' is the name of the subform control, not of the loaded
subforms.

mfG
--> stefan <--
 
Back
Top