Combo box and message box??

[ekta]

Hi:

I have a combobox on my form that has values: Active, Leads, Lost, Pending, Retired, Won. Users want that when the value in the combo box is changed to Pending or changed to Active a message box should pop-up telling them to make an entry in another field. The message box should NOT pop up when they select the value Pending or Active in a new record. Only when they change the value in an existing record.

How can this be done?

Thanks,

Ekta

 

[ekta]

Thanks Pat.