[AccessD] Fw: Access Question: Modal Form Question

Couple of ideas . . .

1.	Pass the values via the OpenArgs of the modal form, and use code
in the OnOpen event of the the modal form to push the passed values to
their places.  Could get ugly parsing the OpenArgs if there are lots of
values to manipulate.

2.	Push the values from the calling procedure to global variables
and read them on open of the modal form.

Haven't tried any of these, but that's where I'd start playing . . .

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
- Beach Access Software
Sent: Thursday, October 27, 2005 8:46 AM
To: AccessD at databaseadvisors.com
Subject: [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?



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com