Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 16th, 2004, 02:18 PM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default Suspend Processing during Form Display

I am using VBA to open a second/child form from the parent form, and would like to be able to suspend processing in the parent form, until the child form is closed. Does anyone know if this is possible, and if so, how it can be done?

DoCmd.OpenForm "frm_Child"
[Wait until Child closes]
strVariable = strAnotherVariable

Thanks

Mike
EchoVue.com
__________________
Mike
EchoVue.com
 
Old November 17th, 2004, 07:24 AM
Authorized User
 
Join Date: Jul 2003
Location: Stockton on Tees, , United Kingdom.
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Add the 'Dialogue' parameter to the open form statement for the subform.

Cheers Ray
 
Old November 17th, 2004, 11:09 AM
Friend of Wrox
 
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

So many options - So little time!!

Thanks for helping narrow it down.

Mike

Mike
EchoVue.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you suspend constraints? Aaron Edwards SQL Server 2005 2 July 31st, 2006 12:16 PM
Get user input during form processing echovue PHP How-To 3 June 10th, 2006 11:54 PM
Display page while processing echovue Classic ASP Professional 1 May 28th, 2006 09:30 AM
form validation and processing GOUR CHANDRA PAUL PHP How-To 1 April 22nd, 2006 03:07 PM
PROBLEM IN FORM PROCESSING GOUR CHANDRA PAUL PHP Databases 0 April 22nd, 2006 01:18 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.