[AccessD] Not In List Not the Right Solution

Thanks.  The not in list occurs in the combo box which is used to select a
name for the form that the combo box is on.  So, can't open the form - it's
already open.

I've used NIL so many times I just copy and paste now, and always works to
add an entry to the combo box.  But this was a bit different. 

Don't know why it turned into such a hash, but I did my workaround and that
turned out a skosh more slicker than the NIL approach from the user's side
of the table.

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:49 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>   

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