Combo Box and On Not in List

[dmugan]

Hello:

I checked Limit to List Yes and placed a macro in On Not In List. However, once the user types in data that is not in the list, I get this pop-up error message - "The text you entered isn't an item on the list, Select an item from the list, or enter text that matches one of the items listed". I would like to get rid of this message and execute the macro which opens up a form to input the new record. Any idea how to get rid of the message?

Thanks

 

[namliam]

I asumme your talking about a bit of VBA instead of a real Macro...

If so add:
Response = false
to your code, this will prevent the message from popping up

I wouldnt know how to prevent it from a macro, might even be not posible. 1 peace of advice if you do use a macro.... DONT... VBA is more flexible and more powerfull.....

Regards

The Mailman

 

[SforSoftware]

I thought I heard sometime that the message can be prevended by an action SetWarnings=False