[AccessD] (no subject)

Edward S Zuris edzedz at comcast.net
Fri Jun 13 10:38:23 CDT 2008


 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



More information about the AccessD mailing list