how to press a button from a different form without sendkey

  • Thread starter Thread starter akko
  • Start date Start date
A

akko

Hi,

i want to replace the sendkeys{enter} function with something else cause
vista makes trouble.

i want to press a button from a different form without using sendkey.

any suggestions.

txs
akko
 
Hi,

i want to replace the sendkeys{enter} function with something else cause
vista makes trouble.

i want to press a button from a different form without using sendkey.
Click to expand...

In general, you'd be better off moving the code in that button to a Public Function (or Sub) and calling that function
in both your Button_Click and from your other forms. For example:

Sub MyButton_Click()
DoCmd.OpenForm "SomeFormName"
End Sub

Would become:

Public Function OpenMyForm()
DoCmd.OpenForm "SomeFormName"
End Function

And you'd then change the Click event to this:

Sub MyButton_Click()
OpenMyForm
End Sub

Other objects could then call this Function on your form:

Forms("NameOfFormWhere_OpenMyForm_Lives").OpenMyForm

The only caveat is the the form hosting the code MUST be open, otherwise the call will fail. If this is code that would
be used in many different places (and isn't specific to the form), then you might want to move it to a Standard Module,
which is always available to all objects.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
Back
Top