Rocky Smolin
rockysmolin at bchacc.com
Tue Jan 13 18:13:25 CST 2015
Contrary to my experience as well Jurgen. Inexplicable. Although there’s going to be something obvious, I know. The Not In List event is firing for every combo box in the app and the Limit To List property is set to No. Go figure. I’ll try the nuclear option of deleting and recreating the control, but I already deleted it and copied a ‘not in list working’ combo box, change the control source and row source, added the after update and not in list events - no cigar. Curious no? R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jurgen Welz Sent: Tuesday, January 13, 2015 4:00 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Not In List Event Not Triggering Ok. It's just that the Not In List event won't even fire if the limit to list property is set to 'No'. Perhaps the combo name is spelled incorrectly in the event procedure. I would go to the Event tab of the control and hit the ellipsis after the [Event Procedure] to make absolutely certain that the code is in the correct control's event. The fact that you're prompted at all means that the event has fired. It's just not running any code which means it's not connected to the code. In other words, I don't understand your email prior to the last because it is contrary to my experience. If that fails, add the control again. Ciao Jürgen Welz Edmonton, Alberta > From: rockysmolin at bchacc.com > To: accessd at databaseadvisors.com > Date: Tue, 13 Jan 2015 15:42:34 -0800 > Subject: Re: [AccessD] Not In List Event Not Triggering > > Tried that and got “ the text you entered isn’t an item in the list.” > Which is what I would expect. (Which of course Access being Access > means we should try it anyway:)) > > > R > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jurgen Welz > Sent: Tuesday, January 13, 2015 3:36 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Not In List Event Not Triggering > > Try 'Yes' just for this one. > > Ciao > > Jürgen Welz > > Edmonton, Alberta > > > From: rockysmolin at bchacc.com > > To: accessd at databaseadvisors.com > > Date: Tue, 13 Jan 2015 15:18:16 -0800 > > Subject: Re: [AccessD] Not In List Event Not Triggering > > > > No. Set to No. If set to Yes it gives the access message the text > > you entered isn’t an item in the list. > > > > All the combos in this app with a Not In List event have the Limit > > to List property set to No. > > > > r > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jurgen > > Welz > > Sent: Tuesday, January 13, 2015 2:51 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Not In List Event Not Triggering > > > > Limit to List property of the combo (Data tab) set to Yes? > > > > Ciao > > > > Jürgen Welz > > > > Edmonton, Alberta > > > > > From: rockysmolin at bchacc.com > > > To: accessd at databaseadvisors.com > > > Date: Tue, 13 Jan 2015 14:44:52 -0800 > > > Subject: [AccessD] Not In List Event Not Triggering > > > > > > Dear List: > > > > > > This one's got me stumped. A combo box has a not in list event. > > > Entering a value not in the list does NOT trigger the event. > > > > > > The field before this one is also a combo box with a Not In List event. > > > It's working perfectly. > > > > > > I can't see ANY difference between the two but there must be something. > > > > > > I did a decompile just to cover that option. No cigar. > > > > > > Any idea - no matter how outlier - is welcomed. > > > > > > MTIA > > > > > > Rocky > > -- > 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com