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