[AccessD] Syntax to Call a procedure from another form

To use Call, replace the first ! with a . as shown:

Call Forms.frmManageMultipleAssets.cmdAdd_Click

Dan Waters
Quality Process Solutions


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Wednesday, March 05, 2003 11:35 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Syntax to Call a procedure from another form


Chris, John, Lambert:

Got it.  Thank you.

Normally, when I call a procedure I use 'Call'.  You don't need it but
it makes the code more self documenting.  In this case however, Access
did not like the 'Call' in front of the
'Forms!frmManageMultipleAssets.cmdAdd_Click'

Rocky

----- Original Message -----
From: "Chris Mackin" <chris at denverdb.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, March 05, 2003 9:13 AM
Subject: RE: [AccessD] Syntax to Call a procedure from another form


> You need a Public sub if it's called from another form, and then the
syntax
> is just:
>
> Forms!frmName.SubName
>
> Chris Mackin
> Denver Database Consulting, LLC
> www.denverdb.com
>
>
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach
> Access Software
> Sent: Wednesday, March 05, 2003 10:04 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Syntax to Call a procedure from another form
>
>
> Dear List:
>
> I always have trouble with this syntax:  I want to execute or call a
Private
> Sub in one form (which is open) from a pop up form.  Can' remember the

> syntax.  Anybody know offhand?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
>
>
>
> _______________________________________________
> 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