Solved Navigate to a text box in a sub form to put a value by a button

[Hulk009]

hello
in my form i have a button when i press it i want it to fill up many text box (RA - MM1 - MM2)
those many text are in a sub form called "TB01"

i've tried this code:

Private Sub Command166_Click()
Me.Parent.Tb01.RA.Value = 27459
Me.Parent.Tb01.MM1.Value = 27894
Me.Parent.Tb01.MM2.Value = 44004
End Sub


it give me Error ... any help with it

 

[Gasman]

Marked as Solved?

If not solved, it's syntax depends on where that code is running.

Forms: Refer to Form and Subform properties and controls

And you cannot possibly say what the error is?

 

[Gasman]

I think the O/P is just confused?
If the code was in the mainform then Parent would not be used, but .Form should be?
If in the subform, again no need for Parent or subform control name.

From the very little posted I think the button is on the mainform and the textboxes in the subform, so the link should show them the syntax.