[AccessD] SubForm and form

jwcolby jwcolby at colbyconsulting.com
Wed Sep 5 13:48:00 CDT 2007


I have been trying to build one but kept getting page faults when I tried to
have access build the event sinks in the main form class.  Sigh.  I did the
"office update" thing and am trying again. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Wednesday, September 05, 2007 2:03 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SubForm and form

Hi John:

You would not have a simple example of this implementation would you?
Withevent/Subform/Form

TIA
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, September 05, 2007 5:43 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SubForm and form

You can also declare a pointer to the form WithEvents and then sink any of
the form's events in the main form.  Doing that allows you to see the
subforms events from up in the main form and select them.  When you select
one of the events, VBA creates an event handler up in the main form.

Click events and enter/exit events usually do not have a problem but you
should remember that subforms load before the main form's class module so
events like OnOpen and such cannot reference code up in the main form until
the main form's class has finished loading. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Tuesday, September 04, 2007 10:07 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] SubForm and form

Hi All:

I just can not remember... too tied... too old. But how can a 'click' on a
field within a subform be monitored and can subsequently produce a result on
the main form?

TIA
Jim 

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