I want to start a click procedure tied to a form upon opening the form. I want to do that in code for a click procedure in another form. Is that possible? I have the following:

Sub Start_Click()
(stuff goes here)
    DoCmd.Close acForm, "frmBlank1_EPD", acSaveYes
    DoCmd.OpenForm ("frmBlank2_TermAndValue")
end sub

That works fine to open the second form, frmBlank2_TermAndValue. However, I can't figure out how to get
frmBlank2_TermAndValue to run its Go_Click procedure (for command button named
"go") upon opening the form. When I set the on open property to run the Go_Click procedure as shown below, I get an error generated by frmBlank2_TermAndValue's error handler.

Private Sub Form_Open(Cancel As Integer)
Go_Click

Rick Neifeld, Ph.D. Patent Attorney
President, Neifeld IP Law, PC
2001 Jefferson Davis Highway, Suite 1001
Arlington, VA 22202
Tel: 703-415-0012
Fax: 703-415-0013
Email: rneifeld@neifeld.com
www.Neifeld.com

You could set a new Sub that is called by both the Form_Open and the Go_Click events:

Private Sub newSub()
  DoCmd.Close acForm, "frmBlank1_EPD", acSaveYes
  DoCmd.OpenForm ("frmBlank2_TermAndValue")
end sub

Private Sub Form_Open(Cancel As Integer)
 newSub
End Sub

Private Sub Go_Click(Cancel As Integer)
 newSub
End Sub

Hope that helps


-Shay Shepston