[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