[AccessD] Call an event in another form

William Benson (VBACreations.Com) vbacreations at gmail.com
Mon Aug 15 17:50:20 CDT 2011


Lately I have been calling functions from most events. 


Private Sub SaveRecord_Click()
Call SaveRecord
End Sub



Sub SaveRecord()

'Do the stuff SaveRecord_Click() would do

End Sub


And based on this I seem to be able to call it easily from any form


'In some other form
Private Sub
     Call Forms("OtherForm").SaveRecord   'As long as OtherForm  is open
End Sub



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, August 15, 2011 5:56 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Call an event in another form

In that case, ignore my subsequent post <g>

-- 
Stuart

On 15 Aug 2011 at 14:33, Rocky Smolin wrote:

> Nope, my bad  Public works.  Think I had to recompile.
> 
> Thanks
> 
> Rocky
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky
> Smolin Sent: August 15, 2011 2:19 PM To: 'Access Developers discussion
> and problem solving' Subject: Re: [AccessD] Call an event in another
> form
> 
> Yeah, doesn't help, though, I think the error's being generated by the
> syntax of the calling statement - I think it never gets so far as to
> look for the sub. 
> 
> R
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan Sent: August 15, 2011 2:17 PM To: Access Developers
> discussion and problem solving Subject: Re: [AccessD] Call an event in
> another form
> 
> Have you declared lblTime0_CLick as Public in the form module?
> 
> --
> Stuart
> 
> On 15 Aug 2011 at 14:07, Rocky Smolin wrote:
> 
> > Dear List:
> > 
> > I am trying to call the sub lblTime0_Click() which is in the CBF
> > frmMatterButtonsHorizontal.
> > 
> > Using:
> > 
> >     Call Forms("frmMatterButtonsHorizontal").lblTime0_Click
> > 
> > gives me an application-defined or object-defined error.
> > 
> > What is the correct syntax?
> > 
> > MTIA
> > 
> > Rocky Smolin
> > Beach Access Software
> > 858-259-4334
> > www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> > <http://www.e-z-mrp.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
> 
> --
> 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
> 



-- 
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