[AccessD] Call an event in another form

Rocky Smolin rockysmolin at bchacc.com
Mon Aug 15 18:04:23 CDT 2011


As an aside, I'm using this to determine if a form is loaded:

If CurrentProject.AllForms("SearchScreen").IsLoaded = True Then

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
(VBACreations.Com)
Sent: August 15, 2011 3:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Call an event in another form

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

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