Click

[dekelc]

How can I call a click procedure of a command button from another form?

[pvbangera]

u cannot call a click procedure of a button of another form because it is private to that form. u can do one thing. create a public procedure in your start up module. And you can call that procedure from any form.

hope this will solve your problem

regards,
prakash

[Hack]

You don't necessairly have to put a sub in a module. You can make a Public sub on a form. If the sub on the form is Public, it can be called from another form.

[pvbangera]

can we declare a public sub in the form? i am not sure!!

[Leather]

Create Public Sub in the form with the click event...

Public Sub RunClick()
CommandButton1_Click
End Sub

The call this from wherever it is needed..

MyForm.RunClick

[Leather]

An easier alternative is to simply use the following..

MyForm.CommandButton1.Value = True

This will run the click event of commandbutton1 and does not require any extra subs...

[Hack]

Calling click events from buttons of any sort on a different form poses a problem in that all click events are Private to the form. It is better to create a Public sub on the form. That can be accessed easily.

[Leather]

Yes, but all controls on a form are available...

So are there properties...

Setting the value property of a command button to true fires its click event...

[Hack]

Originally posted by Leather
Setting the value property of a command button to true fires its click event...

You are correct providing the button resides on the same form that is doing the calling.

[MarkT]

Originally posted by Hack
You are correct providing the button resides on the same form that is doing the calling.

NO NO NO not true. Try this
form1

Option Explicit
 
Private Sub Command1_Click()
    Form2.cmdTest.Value = True
End Sub

Form2

Option Explicit
 
Private Sub cmdTest_Click()
    MsgBox "Form2"
End Sub