Drew Wutka
DWUTKA at Marlow.com
Tue Jun 5 15:32:52 CDT 2007
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.