[AccessD] Filtered combos - Events don't fire

IIRC you need to handle the subform control's LostFocus event to reach back to the combos in the 
subform.  The nice thing about using a class system is that once it works, it is "just available" 
after that.

I'm working on it.

John W. Colby
www.ColbyConsulting.com


Charlotte Foust wrote:
> I always had to have a secondary routine in the GotFocus and Enter event
> of the parent to handle that situation.  It's because of the order of
> precedence of the events.
> 
> Charlotte Foust 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Thursday, March 05, 2009 12:52 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Filtered combos - Events don't fire
> 
> I ran into something that I don't remember, or perhaps I never quite
> figured out.
> 
> In a subform, the Exit and LostFocus events of a control do not fire if
> you click entirely out of the subform into the parent form or into a
> control on another subform.  That is a PITA!
> 
> It appears that the logic is simply that the control never lost the
> focus IN IT'S FORM. 
> Unfortunately this wreaks havoc with setting the unfiltered sql back
> into the combo's RowSource property.
> 
> What a PITA.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>