[AccessD] Not In List Not the Right Solution

You can use the NotInList event, put code there to add the value to the
rowsource, whatever that may be, and then requery the combobox.  The trick
is the response value of acDataErrAdded, which tells Access the record is
being added and to stop asking about it.  Here's a link that should help:
http://support.microsoft.com/kb/197526?

Charlotte


On Tue, Apr 9, 2013 at 9:23 AM, Rocky Smolin <rockysmolin at bchacc.com> 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
>