Pathing for Sub-form inbeded in a Tab Control

Question

I am trying to delete a record from a multi record sub-form that was added to a Tab control via vba but I am not sure how to reference a  sub-form yet alone a sub-form in a Tab control. 

The Parent Form is: "Applicants"

Tab Control: "Tab_More"

Sub Form: "Skills"

Any examples would be much appreciated. 

Answer 1

The subform should have a Name. Use Me.SUBFORMNAME.Form to get a reference to the form within that control. InteliSense doesn't work usually, so make sure your code is correct. Like if the PK on the child form is a CustomerId you can use: Me.Child0.Form.txtCustomerId or Me.Child0.Form.Recordset.Fields("CustomerId").Value to get the PK on the record where the cursor is currently at on the Multi record subform.

Answer 2

Thanks HTHP that is exactly what I needed.