Call Command_Click

[david.allan.johnson@redsa]

Can someone advice me on how to run the Command405_Click button that's on the (Parent form) from the (child Subform) using a Command330 button?

 

[Gasman]

Firstly give your controls meaninful names. Command405 is not going to mean anything to you or anyone else 6 montns down the road.
Most developers do not recommend calling control events directly.

Create a common sub and call it from your both your command buttons.

 

[Gasman]

FWIW ChatGPT shows

Private Sub cmdSubButton_Click()
    ' Call the main form's command button click event
    Call Forms!frmMain.cmdMainButton_Click
End Sub

I would have tried with Me.Parent.cmdMainButton_Click

 

[david.allan.johnson@redsa]

FWIW ChatGPT shows

Private Sub cmdSubButton_Click()
    ' Call the main form's command button click event
    Call Forms!frmMain.cmdMainButton_Click
End Sub

I would have tried with Me.Parent.cmdMainButton_Click

I tried calling the command button directly, but it doesn't work.

 

[Gasman]

I tried calling the command button directly, but it doesn't work.

Well that code should work?, but as I mentioned a common sub getting called is the best practice.

 

[MajP]

By default Event Procedures are Private so even if you get the syntax correct it will not work. You would have to change to public and then do what @Gasman suggests. However, as he mentioned it is cleaner to break it off into a stand alone procedure that the click event calls and then the subform can call

 

[david.allan.johnson@redsa]

T

By default Event Procedures are Private so even if you get the syntax correct it will not work. You would have to change to public and then do what @Gasman suggests. However, as he mentioned it is cleaner to break it off into a stand alone procedure that the click event calls and then the subform can call

That worked!!! Thanks : )

 

[Gasman]

T

That worked!!! Thanks : )

You can lead a horse to water.....