A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Form will not stay open



 
 
Thread Tools Display Modes
  #1  
Old June 21st, 2004, 03:50 PM
Rich
external usenet poster
 
Posts: n/a
Default 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  
Old June 21st, 2004, 04:40 PM
Edm
external usenet poster
 
Posts: n/a
Default 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  
Old June 21st, 2004, 08:21 PM
John Vinson
external usenet poster
 
Posts: n/a
Default 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  
Old June 21st, 2004, 08:39 PM
Rich
external usenet poster
 
Posts: n/a
Default 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  
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.