combo's

[AN60]

I need assistance with combo boxes. I want to add items to the drop down list in a combo box and have the new item saved in the drop down. I've looked up numerous notinlist threads and tried to adapt their answers but without success. I wish to use both bound & unbound combo boxes, so is the notinlist event different for those? If you have an answer please remember I am an Access "Pigmy" ie. new and don't know much yet. I use access 97 and 2000 at present (mostly 97).

 

[dcx693]

Try looking at this article. It might clear up some things: Add item to combo box using OnNotinList event. It doesn't matter if you have a bound or unbound combo box, the NotInList event fires the same way: it fires when you try to enter an item which is not in the combo box.

 

[AN60]

Thank you for your reply dcx. Unfortunately I must be missing something as the information in your link failed to work. As I said my knowledge of access is limited so I'll list what I did;
1 Created a new unbound combo
2. Set Limit to List to Yes
3. clicked On Not In List (event proceedure)
4. Pasted the data from the link you provided into the Not in list section, with my (me) combo's name
5. Edited the data with the name of my own combo (combo91)
6 saved
7. entered a name or text in the combo
8. message telling me that I had entered something which was not in the drop down list (one thing I did know).
That's It! I couldn't go any further?

I am guessing that my editing was at fault but from memory there was only one edit, that being in the first row?

 

[pcEars]

AN60

2. Set Limit to List to Yes

Doesn't that prevent your new code from adding to the list?

 

[AN60]

PC
From memory easc set of instructions said to set it to yes. I'm trying to do as told....? maybe I should go try no. Thanks.