View Single Post
  #5  
Old June 21st, 2004, 10:13 PM
John Vinson
external usenet poster
 
Posts: n/a
Default Form will not stay open

On Mon, 21 Jun 2004 12:39:31 -0700, "Rich"
wrote:



I'm not a macro expert (I prefer VBA), but I know that

the VBA Close
method allows you to specify the name of the form to

close. Does the
Macro event give you the same option? If so, specify

which form.

Yes, macros do give you the option of specifing which
form which is the wierd part as they both close although
only one is specified


Odd! Could you post the actual steps of the macro?

Fwiw, the VBA code would be

Private Sub cmdClose_Click()
DoCmd.Close acForm, "NameOfTheFormToClose"
End Sub

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public