Autopopulate in Subform witih subform control

[Monstermechanic]

Having issues with auto population in a subform using a subform button control.
The code obviously works when in form mode but when as a subform object form cannot be found.

Private Sub Command13_Click()
[Forms]![VSM - Vendor Surveillance Findings]![Text29] = ("Transferred item to a VCAR for investigation, disposition, and corrective action.")
End Sub

Help

 

[MarkK]

A Subform is not a member of the Forms collection. To refer to a subform you need refer to the Form property its subform control container.

Forms!FormName.SubformControlName.Form.ControlName = <data>

 

[Monstermechanic]

Have not worked with VBA very much.
The form name is VSM - Vendor Surveillance Discrepancy
The sub form is located in Child14
The subform name is VSM - Vendor Surveillance Findings
The datafield is Test29.

This is what I came up with and I just can't figure this one out.


Code:

Private Sub Command13_Click()

[Forms]![VSM - Vendor Surveillance Discrepancy].[child14].[VSM - Vendor Surveillance Findings].[Text29] = ("Transferred item to a VCAR for investigation, disposition, and corrective action.")
End Sub

 

[Monstermechanic]

Have not worked with VBA very much.
The form name is VSM - Vendor Surveillance Discrepancy
The sub form is located in Child14
The subform name is VSM - Vendor Surveillance Findings
The datafield is Test29.

This is what I came up with and I just can't figure this one out.


Code:

Private Sub Command13_Click()

[Forms]![VSM - Vendor Surveillance Discrepancy].[child14].[VSM - Vendor Surveillance Findings].[Text29] = ("Transferred item to a VCAR for investigation, disposition, and corrective action.")
End Sub

 

[MarkK]

Try ...

Forms![VSM - Vendor Surveillance Discrepancy].child14.Form.Text29

 

[Monstermechanic]

Was on Vacation. It worked. Thank you so much.
Now I just have to re-grow my har back.