Show Result From Subform To Main Form In Text Box

[aamer]

Have Subform "Admin_Purchase_Subform" on this subform have a button "EditBtn" with a code


Private Sub EditBtn_Click()


Me.AllowEdits = True
Me.AllowDeletions = False
Me.Kaption = "EDIT MODE !!!"


End Sub


If I Clik On "EditBtn" the textbox "Kaption" on Subform "Admin_Purchase_Subform" it shows EDIT MODE !!!


but I want this textbox "Kaption"on Main Form "Admin_Purchase_Payments_Main_Form" how can I do that, it shows the EDIT MODE !!! on the Main Form.

[Micron]

Me refers to the form that the code is behind. Try Me.Parent.Kaption = "EDIT MODE !!!"
That assumes there is a control by that name on the main form.

[aamer]

Have another issue needs help
this time am accessing from main form "Admin Purchase" to subform "Purchase Subform"
the button is placed on main form


the code i tried to execute is the following. but its not working


Private Sub NewEntryBtn_Click()
Me.Form.[Purchase Subform]!NewEntryBtn = DoCmd.GoToRecord , "", acNewRec
End Sub

[Minty]

That syntax is completely incorrect. Press compile and it will tell you, you can't just randomly string commands you think might work together.
What are you trying to do - go to a new record on the sub form?

Something like

Private Sub NewEntryBtn_Click()

     DoCmd.GoToRecord acDataForm, [COLOR=var(--highlight-variable)]"Purchase Subform"[/COLOR], acNewRecEnd Sub

Might work, assuming the form names are correct.

[aamer]

That syntax is completely incorrect. Press compile and it will tell you, you can't just randomly string commands you think might work together.

What are you trying to do - go to a new record on the sub form?

Something like

Private Sub NewEntryBtn_Click()

    DoCmd.GoToRecord acDataForm, [COLOR=var(--highlight-variable)]"Purchase Subform"[/COLOR], acNewRecEnd Sub

Might work, assuming the form names are correct.

Yes am trying to go to New record from "Admin Purchase" to "Purchase Subform".
your suggested following code did not work.


DoCmd.GoToRecord acDataForm, "Purchase Subform", acNewRec