Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Jun 13 09:50:21 CDT 2008
Public! Go it. Thanks Ed. And Dan. It's working now.
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S Zuris
Sent: Friday, June 13, 2008 8:38 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] (no subject)
The subroutine you call has to be public.
=================================================
=================================================
Dim zzForm As Form
. . .
' ***********************************************
' Call some VBA Public Code from another Form.
'
Set zzForm = [Forms]![zJP709aBookEdit]
Call zzForm.aaLoadBookMark
Set zzForm = Nothing
=================================================
=================================================
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, June 13, 2008 7:25 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] (no subject)
Dear List:
I am having trouble calling a module in a main form from a subform. Syntax
problem again.
There's a module in the main form called FilterActionsSubform and I want to
call that from the double-click event of a control on another subform but I
can't seem to get the syntax right.
Call Forms.Parent.FilterActionsSubform doesn't work.
Call Forms.Matter.FilterActionsSubform doesn't work.
Does anyone know the right way to do this?
MTIA
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com <http://www.e-z-mrp.com/>
www.bchacc.com <http://www.bchacc.com/>
--
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
No virus found in this incoming message.
Checked by AVG.
Version: 8.0.100 / Virus Database: 270.3.0/1501 - Release Date: 13/6/2008
06:33