[AccessD] Fw: Access Question: Modal Form Question

Dear List:

This is from a friend.  Any ideas on this?  

MTIA,

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com
858-259-4334

----- Original Message ----- 
From: "Mike Dwyer" <mike at aesadvantage.net>
To:Sent: Wednesday, October 26, 2005 6:49 PM
Subject: Access Question: Modal Form Question


Ok, I know this has been discussed before so here goes again...

1.  I have a form that must be opened as a dialog box.
2.  This form is called from one or more VB procedures.
3.  Before this form goes "Modal" I need to change some values on this
form from my VB procedures.

4.  While this form is "Modal", all other code must be suspended.

My catch 22 is that I need to manipulate this Modal form to change
values on it but opening this form as DIALOG causes all code to stop.
Opening this form regularly, setting my values, and then setting the
form's Modal property doesn't stop my other code from executing.

Anybody got a solution?