philippe pons
phpons at gmail.com
Mon Feb 9 12:39:04 CST 2009
the proc. is within the form where the combo resides. So I'm calling SyncCboTest from the form itself. Thank's for your help. NB: yes, I stay tuned!!!! 2009/2/9 jwcolby <jwcolby at colbyconsulting.com> > Philippe, > > If you go the class route, then you place the AfterUpdate event of the > combo in the class itself. > Because the AfterUpdate event for THIS SPECIFIC Combo exists in the class > itself, then the name > never changes(!) and it is within the scope of the class. > > Where are you calling SyncCboTest() from? > > I will be doing a combo class in the lecture that I am doing so stay tuned. > > John W. Colby > www.ColbyConsulting.com > > > philippe pons wrote: > > Hi John, > > > > yes, I know you're a class and withevents guru! > > I'll try this way, but if I remenber well your explanations of the > > withevents statement, I recall > > it allows a class to SINK the event of a control, but can it CALL an > event > > of tis control, not sure! > > > > Thank's for your help, > > > > Philippe > > > > 2009/2/9 jwcolby <jwcolby at colbyconsulting.com> > > > >> This is possible, IF the AfterUpdate event exists within the scope of > the > >> calling subroutine and is > >> actually called cbo_AfterUpdate. > >> > >> If you have a cboPerson and cboState and cboCity then the event to call > >> would be > >> cboPerson_AfterUpdate, cboState_AfterUpdate, cboCity_AfterUpdate. You > see > >> what I am saying? > >> > >> My guess is the cbo is not CALLED cbo back where it exists. You are > trying > >> to use a function to > >> make something generic but the NAME of the objects AfterUpdate is not > >> generic, and very likely the > >> code cannot be seen from this function, the afterupdate sub is in the > >> form's class and this function > >> is where? In a module? Not the same scope. > >> > >> So no, you probably cannot do what you are trying to do. > >> > >> Now... if you had a class for your combo... > >> > >> ;-) > >> > >> John W. Colby > >> www.ColbyConsulting.com > >> > >> > >> philippe pons wrote: > >>> Hi all, > >>> > >>> I have a small proc. to which I pass a reference to a combo box. > >>> This proc has to synchronize the combo on the first item > >>> and run the AfterUpdate event proc. > >>> > >>> Private Sub syncCboTest(ByRef cbo As ComboBox) > >>> ' syn de la cbo de sélection du chapitre > >>> cbo.SetFocus > >>> cbo = cbo.ItemData(0) > >>> ' Call cboSelChap_AfterUpdate > >>> Call cbo_AfterUpdate '<== this won't work! > >>> End Sub > >>> > >>> The question: > >>> > >>> How would you call the AfterUpdate event of a combobox that is > >> represented > >>> by it's reference?? > >>> something like: cbo_AfterUpdate! > >>> > >>> If it is even possible! > >>> > >>> Best regards, > >>> > >>> Philippe Pons > >> -- > >> 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 >