[AccessD] Not In List Not the Right Solution

if the not in list fires then you can open the form which displays the table, move to the new record 
add the last name and allow them to finish.  If you open the form modal then execution stops back in 
NotInList.  Now when the form closes execution picks up back in the combo and you can requery the 
combo.

I actually do this in my framework.

John W. Colby

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

On 4/9/2013 12:23 PM, Rocky Smolin wrote:
> 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
>