NotInList DAO or ADO?

[AN60]

I added the notinlist event to an unbound combo (I use access 2003) and used the ADO code but no matter what I try I can't get it working. Out of desperation I substituted the DAO code and "bingo" I have a working combo which adds any data I type in etc, no errors no problems. My question now is; Do I now stick with the old rule "if it ain't broke don't fix it" and continue using the DAO code or do I continue to pull my hair out (not much left now) trying to get the ADO code working?

 

[Mile-O]

Since A2003's default is DAO, you could use the ADO code and just tick the reference* for Microsoft ActiveX Data Objects 2.x Library in order to compile the ADO code.

* Open a module, go to Tools -> References

 

[AN60]

I have Microsoft ActiveX Data Objects 2.x Library selected (ticked) already. I've searched most if not all the notinlist posts and tried most of the "tricks" but the ADO eludes me. The best I could do was to get the notinlist message box to appear with a following message "List Mismatch". I'm happy with the DAO if it won't create any problems. At least it works just like I want it to.