 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2005code for closing form
On formSelect I use cmdOpen button to open another form (formData). Appreciate any code that I can use to close the current form i.e. formSelect when I click the cmdOpen button. Thanks S Kahn Not sure I'm reading from the same page but how about; writing the code for the command button on click to be DoCmd.Close DoCmd.Openform "NewFormToOpen -- DigiVampPosted from - http://www.officehelp.i You've got it backwards. If you close the current form, you can't open anything from it. BTW, you need to set your computer's clock. It is running slow. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access > Not sure I'm reading from the same page but how about; > writing the code for the command button on click to be [quoted text clipped - 3 lines] > -- > DigiVampPosted from - http://www.officehelp.in > You've got it backwards. If you close the current form, you can't open > anything from it. Actually you can issue the DoCmd.Close first and any code lines that follow it are still executed.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Thanks all, works great. S. Kahn > Actually you can issue the DoCmd.Close first and any code lines that follow it > are still executed. Right you are. This obviously must be an exception to the general rule of VB and VBA supposedly executing sequentially, with each statement finishing before the next starts. I tried adding a delay loop between statements to see if it would react as expected. It still finishes. Good catch. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access > On formSelect I use cmdOpen button to open another form (formData). > Appreciate any code that I can use to close the current form i.e. formSelect > when I click the cmdOpen button. Simply open and close the forms. From a button: DoCmd.OpenForm "Form To Open" DoCmd.Close acForm, "Form To Close" -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.