Add data to list on fly

I was wondering if there is a way to add a new entry to a list in a drop
down box if it is not in the list when you type it. The list is in the row
source control for the box.

I would also like to know what the best teaching book is for access......

Thanks
Tim

You need to set the combobox's LimitToYes property to True (Yes), and add
code to its NotInList event.

There's a sample of the code required at
http://www.mvps.org/access/forms/frm0015.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Tim Leach" wrote in message
.. .
I was wondering if there is a way to add a new entry to a list in a drop
down box if it is not in the list when you type it. The list is in the row
source control for the box.

I would also like to know what the best teaching book is for access......

Thanks
Tim

On Sat, 12 Jun 2004 06:51:52 -0400, Douglas J. Steele wrote:

You need to set the combobox's LimitToYes property to True (Yes), and add
code to its NotInList event.

There's a sample of the code required at
http://www.mvps.org/access/forms/frm0015.htm at "The Access Web"

Thank you Douglas, I will give it a try.