Arthur Fuller
fuller.artful at gmail.com
Tue Jun 5 17:45:44 CDT 2007
I just whipped up a little unbound tester with one combo and one date field defaulted to today and one OK button. I included debug statements in the Exit, AfterUpdate and Change events. All of them are firing just fine. I don't know what might be going wrong but I don't seem to be experiencing it. A. On 6/5/07, Charlotte Foust <cfoust at infostatsystems.com> wrote: > > VB combos don't have the same events as Access comboboxes. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka > Sent: Tuesday, June 05, 2007 1:33 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Unbound events > > Too busy to look this up, in VB, this is what I use. It might be > different with an Access combobox, but I don't remember having to use > anything else. > > Drew > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, > Lambert > Sent: Tuesday, June 05, 2007 3:14 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Unbound events > > I regret I have to disagree with Drew. > > There's no question in my mind that the After_Update event is the one > you need, John. It's the only event that happens after the user has > selected something. > > I'm looking at an unbound form right now, and the after_Update event > *does* > fire on the combobox. > > If it's not doing so for you then I'd suspect a corrupt form. > > > Lambert > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka > Sent: Tuesday, June 05, 2007 2:55 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Unbound events > > > For a combo box, you'll want to use the OnClick event. > > Drew > > ________________________________ > > From: accessd-bounces at databaseadvisors.com on behalf of jwcolby > Sent: Tue 6/5/2007 1:28 PM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] Unbound events > > > > Perhaps one of the unbounders out there can lend some insight on what > events will fire for unbound controls on unbound forms. I am trying to > do a simple "set a date in a textbox when a combo selects an item". I > have tried the AfterUpdate and OnExit of the neither of which seems to > be firing. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > <http://www.databaseadvisors.com/> > > > > The information contained in this transmission is intended only for the > person or entity to which it is addressed and may contain II-VI > Proprietary and/or II-VI BusinessSensitve material. If you are not the > intended recipient, please contact the sender immediately and destroy > the material in its entirety, whether electronic or hard copy. You are > notified that any review, retransmission, copying, disclosure, > dissemination, or other use of, or taking of any action in reliance upon > this information by persons or entities other than the intended > recipient is prohibited. > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com The information contained in > this transmission is intended only for the person or entity to which it > is addressed and may contain II-VI Proprietary and/or II-VI > BusinessSensitve material. If you are not the intended recipient, please > contact the sender immediately and destroy the material in its entirety, > whether electronic or hard copy. You are notified that any review, > retransmission, copying, disclosure, dissemination, or other use of, or > taking of any action in reliance upon this information by persons or > entities other than the intended recipient is prohibited. > > > -- > 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 >