If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form will not stay open
Hi,
I currently working on a muti-tab form where one of the pages has a command button that opens another form. This continous form displays some queried data and a command button that has a macro to close the form. However, this macro closes both the muti-tab form and the continous form. (only the countinous form should close). Both forms are modal and pop-up enabled. I would be much obliged if anyone had any ideas. |
#2
|
|||
|
|||
Form will not stay open
-----Original Message----- Hi, I currently working on a muti-tab form where one of the pages has a command button that opens another form. This continous form displays some queried data and a command button that has a macro to close the form. However, this macro closes both the muti-tab form and the continous form. (only the countinous form should close). Both forms are modal and pop-up enabled. I would be much obliged if anyone had any ideas. . Use the DoCmd.Close(?) before you open your new form in your code. Thats the solution Ive used on my forms. It might work for you. |
#3
|
|||
|
|||
Form will not stay open
On Mon, 21 Jun 2004 07:50:14 -0700, "Rich"
wrote: Hi, I currently working on a muti-tab form where one of the pages has a command button that opens another form. This continous form displays some queried data and a command button that has a macro to close the form. However, this macro closes both the muti-tab form and the continous form. (only the countinous form should close). Both forms are modal and pop-up enabled. I would be much obliged if anyone had any ideas. 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. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#4
|
|||
|
|||
Form will not stay open
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|