[AccessD] sub form procedure

John,

You can use Current event of Subform.

But set also a flag in Combo's AfterUpdate event if Form's module (code
behind) and check this flag in Subform's Current event -
Me.Parent.{{FlagName}}...

Parent form's hidden textbox's value can be also used as flag value instead
of code behind module level variable/property...

While checking the flag in Subform's Current event take into account that
when Subform is getting created(/opened/loaded) its Parent form doesn't
exist yet...

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
Sent: Friday, June 06, 2008 9:27 PM
To: _DBA-Access
Subject: [AccessD] sub form procedure

I have a combo box that selects a record for a form. After selecting a
record the main forms sub forms need to refresh the data and call a
procedure in their module. The data is refreshed but the procedure won't
run. Que Pasa? What event do I use in the sub form to run a procedure every
time the dataset has changed?
 
A2K3

John B


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com