Click a button from VB - Access 2000

[Dmitry Perets]

Hello,

Is it possible to "click a button" on the form, using the VB code? I have a button which is handled by a macro. And I need to "click" this button from VB (i.e. to execute that macro) when the user presses Enter on a different control on the form.

[olivthill]

I suppose that your button already has a VBA subroutine associated with the onClick event (if not, then rightclick on the button in creation mode, in order to get the property dialog box, and then click on the line for the onClick event). For instance, if your button is named "Bt1", you should see this in the VBA editor:

Private Sub Bt1_Click()
.... blabla
End Sub

Then, this subroutine can be called from anywhere with:

Call Bt1_Click