Prompt on combo box

[craig08]

Good Morning,

I have a form with a combo box to select from several different options. I do not want this amended easily or by mistake, therefore is it possible that when the user clicks the combo box or trys to amend the data a prompt box opens up which asks if they are sure they want to change this information? They will then click yes and it will allow them to change the data.

Thanks in advance.

 

[Kiwiman]

Howzit

Set the Limit to List Property to Yes. You can then use the Not In List Event (search this forum for examples) Procedure to handle what is happens when something else is added

http://allenbrowne.com/ser-27.html

 

[CEH]

Use the "On Dirty" event.