[AccessD] On Open Event

Dan,

I tried this...it does work for the 'On Current'...but unless I'm doing 
something wrong it does not work for the 'On Open'.  It gives the error 
"Argument not Optional".

Any other ideas?

Thanks,

Mark



>From: "Dan Waters" <dwaters at usinternet.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] On Open Event
>Date: Wed, 1 Mar 2006 10:45:35 -0600
>
>Mark,
>
>You can do this:
>
>1) Make the open event a Public sub.
>
>2) Use this:  Call Forms.frmMyForm.Form_Open
>
>You can use this technique to call any procedure in any OPEN form.  I do
>this sometimes to call an open form's Current event from code in a standard
>module.
>
>
>Dan
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: Wednesday, March 01, 2006 9:35 AM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] On Open Event
>
>Hello All,
>
>I have a form that does 'stuff'  'ON OPEN'...is there a way to cause this
>event to fire again from another form...repaint,refresh,requery...anything?
>
>Thanks,
>
>Mark A. Matte
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com