How to Alert user when chang any field in a form

[Falcon88]

I have a form contains :
- Some bound textboxs.
- Some bound comboboxs.
- some unbound textboxs.
- some bound (yes/No) fields.
Q: How to alert user , if there are any change in any bound fields by a msg (not in new record)?

i want a code to alert user with the changed field name , and gives him a choice to continue change or back to the old value , ( directly after changing not when move to another record ) .

 

[NauticalGent]

Take a look at the .OldValue property for controls.

 

[Falcon88]

how to build a custom MsgBox function and call it in the event of beforeUpdate (or dirty ) event for every control , while leaving me to decided what is the name of control that will appeared in the msgbox .
suppose we have a textbox in the form with name :"txtServName" , when call that custom msg , i need it with name "Service Name".

the massage as :"Changes have been made to Service Name field ?

"

 

[NauticalGent]

Well, I could provide you with the code for a custom MsgBox and the instructions on how to invoke it...and I don't mind doing that. However, I would advise against it. Depending on how many controls you are talking about, this could make using your form a VERY tedious experience, one you and your users will soon tire of.

If your intent is to show users new changes and to give them a chance to revert to old values, there is a more efficient approach to this.

 

[Falcon88]

If your intent is to show users new changes and to give them a chance to revert to old values, there is a more efficient approach to this.

Ok ,and very very thanks for your advise.
exactly i want a msg when user change any field (not in new record) exactly after change , or a msg that informs user about some changes in some fields .
if this code would be one, but change name of the field that will appear in that msg when use with that field events , Instead of use the code for every field change event