[AccessD] Not In List Not the Right Solution

The short answer to Tony was that it wasn't a question of adding a new value
to a list - it was adding a new record to the underlying form.

But the client's happier with my alternative approach than the original so
all's well.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Tuesday, April 09, 2013 6:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Not In List Not the Right Solution

Yea Tony!

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 4/9/2013 1:23 PM, Tony Septav wrote:
> Hey Rocky
> I do not understand your problem. From someone so attuned to Access. 
> Do you not trap for Not In List, then popup a form, asking the client 
> to verify they want to add the new entry to the list?  Then in VBA you 
> add the new entry to the lookup table, requery the list and then set 
> focus to the new entry???
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
> Smolin
> Sent: April-09-13 11:24 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Not In List Not the Right Solution
>
> Dear List:
>   
> I have a request from a user that when they try to find a name in a 
> combo box if the name is not there, that the program go to add a new 
> record and place the data entered in the combo box in the last name 
> field and let them finish entering the new data.
>   
> I tried the NotInList event until I realized this is to add entries to 
> the combo box.  But I can't seem to get it to behave properly - it 
> goes into a loop displaying my "add then new guy now?" not in list
message.
>   
> I think Not In List is not the best way to do this, but don't know how
else.
>   
> Any ideas?
>   
> MTIA
>   
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.com/>
> Skype: rocky.smolin
>   

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com