Prevent form updates for certain conditions.

[gg80]

Using a2003 and a 2007. The title for this is weird since I couldn't think of how to summarize. I have a single form with quite a few combo boxes and some buttons. If certain conditions exist and the user tries to make a change, I want the user to get a message that warns him that this item is already ordered. If he has made a mistake by making a change, he can click the undo button on the message box. If he still wants to make a change, he clicks continue and code turns off the warning and allows updates.

For fields on the form, I can use ondirty or keyPress to sense that someone is trying to make a change. For combo boxes, I would like to present the same message when the user tries to use any combo box. Do I have to put code in for each box or is there some way that I can initiate an event if he tries to use any of the boxes?

Any help much appreciated.

[June7]

Code for each combobox unless you want every keystroke or click on the form to trigger code.

[gg80]

Looks like no easy out-I will play with it some more. I was thinking that, after the first rejection and then a decision to carry on, I could set an unbound control to some value that would then allow free changes.

Thanks for quick replay. This site and its quick access to experienced people is wonderful.

[Xipooo]

Assuming you are using a bound form, the Before Update event is where you can verify what the user selects, then if you want to prevent that value from being updated you set Cancel = True and that will cancel the update of the underlying data.

[gg80]

Assuming you are using a bound form, the Before Update event is where you can verify what the user selects, then if you want to prevent that value from being updated you set Cancel = True and that will cancel the update of the underlying data.

The before update doesn't fire until after all the changes have been made, when go to next record etc. I was wanting something that generated a message as soon as tried to make first change in any field or pull down. OnDirty seems to be the closest. One problem for me with onDirty is that it only acts the first time you use it. I have tried setting
Ondirty
Do something with code
me.dirty=false (so will fire again if try to something else on same record.)
This somehow doesn't make the form clean.

Thanks for taking time for this.

[Xipooo]

You would have to set the On Update for every field in your form. There isn't any event currently that fires when any value is changed except for the "On Dirty".