Combo box with add text facility?

[Jay]

Hi,

Is it possible to have some form of drop-down (combo, list?) which also
allows the user the option of inputting a string, if the drop down
doesn't include it.

If anyone could point me in the right direction I'd really appreciate it.

Many thanks,

Jay

 

[John Vinson]

Hi,

Is it possible to have some form of drop-down (combo, list?) which also
allows the user the option of inputting a string, if the drop down
doesn't include it.

Yes, two different ways.

If you want to be able to add the text to the table field even if it's
not in the combo's row source, simply set the Limit to List property
of the combo to No.

If you want to permanently add it to the combo's row-source table, use
VBA code in the combo's Not In List event; set Limit to List to Yes.

John W. Vinson[MVP]

 

[Jay]

Thanks John, I *was* thinkin of the first option, but the second could
come in handy as well. I'm afgraid I'm a total VBA novice. Do you have
any code I could crib?

Many thanks,

Jason

 

[Douglas J. Steele]

http://www.mvps.org/access/forms/frm0015.htm
http://msdn.microsoft.com/library/en-us/vbaac11/html/acevtNotInList_HV05187720.asp
http://msdn.microsoft.com/library/en-us/modcore/html/deovrworkingwithcontrolsonformsreports.asp

Don't worry about what version of Access the articles mention: it's the same
in all versions.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)