Not In List Event

[SamMaynard]

I'm trying to use the not in list event and keep getting errors. I think it has to do with the Micorsoft DAO library. What is a DAO and how do I know which one to add. I'm using Access 2000. Any Help?

Thanks

 

[dk]

Hi,

The NotInList event relates to the Combobox, not the DAO (Data Access Objects) library.

When you say you're getting errors you need to be more specific - what is your situation, what errors are you getting, are you using VBA or properties or what? What is your aim?

DETAILS PLEASE

 

[Corticus]

It might relate..

When I try to capture the not_in_list event on a combo that is named something with and underscore(like cmb_User), I can't capture the event.

Annoying to say the least, my naming convention is very limited these days..

 

[dk]

It might relate..

When I try to capture the not_in_list event on a combo that is named something with and underscore(like cmb_User), I can't capture the event.

Annoying to say the least, my naming convention is very limited these days..

Corticus,

Sorry but I don't get where the link between DAO and the Combobox has come from. The object browser shows the NotInList event as a member of Access' combobox class.

Regarding your particular problem (with the underscores in names) I can't replicate that in Access XP. What version are you using and have you set the LimitToList property to Yes?

 

[Corticus]

I don't see where the link came from either, and I'm using Access2000 so maybe they fixed it.