[AccessD] SubForm and form

Jim Lawrence accessd at shaw.ca
Wed Sep 5 13:06:46 CDT 2007


Thank you Charlotte... I will now have to get up to speed in this. A small
sample would definitely help gelling this.   

Jim

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

All you need to do is declare a form variable at the module level
WithEvents, like this

Dim WithEvents myForm as Form 

That will give you a myForm object in the list of objects in your form
and if you select myForm from the dropdown list, you'll be able to
create shell routines to handle any of the exposed events of a Form.
So you can have a myForm_Load event, for example, which would contain
code you want to run when myForm is loaded.

Charlotte Foust

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

John,

Believe it or not, I initially figured that this could be done because I
do try to learn from your postings! :-)

I gave my suggestion simply because that's what I know how to do.

Could you post a short example code of how you would set up the main
form's monitoring of the subform's events?  I sure would like to manage
a subform's load and open events.

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, September 05, 2007 7: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

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