accessing sub from within

[omozali]

How can I call a sub associated for example with a button from inside my code?

for example
-------------------------
[code]private sub f_click()

end sub
---------------------------
private sub s_click()
 
f_click()  <-- How I call this to run here?
[more code]
endsub

I tried run (f_click()), but didn't work

[missinglinq]

Just like this:

Private Sub s_Click()
   f_click
   [more code]
End Sub
 

[NeoPa]

Are you running this from the same Form module as the F CommandButton is on?
If so then MissingLinq's answer is fine for you.
Otherwise you need to refer to the Form first in the call (I've assumed name of form is frmName to illustrate) :

• Call Form_frmName.F_Click()
• Call Forms("frmName").F_Click()
• Call Forms!frmName.F_Click()

I use the Call command generally as it documents that the code is a procedure call, but this is not necessary for the call to work.

[omozali]

Are you running this from the same Form module as the F CommandButton is on?
If so then MissingLinq's answer is fine for you.
Otherwise you need to refer to the Form first in the call (I've assumed name of form is frmName to illustrate) :

• Call Form_frmName.F_Click()
• Call Forms("frmName").F_Click()
• Call Forms!frmName.F_Click()

I use the Call command generally as it documents that the code is a procedure call, but this is not necessary for the call to work.

excellent thanks alot everybody