Link to home
Start Free TrialLog in
Avatar of hiviper
hiviper

asked on

Need a "confirm change" dialogue when editing MS Access form field

Hi All,
Basically my boss wants an added level of proetection from careless people changing part numbers and quantities in his electronics parts database. So this has to apply to only two fields in the form.

We need a dialogue box to pop up when the user changes the contents of a form field, preferably when they move to the next field or record. There are two special needs here that prevent me from using the "After Update" event in the Properties panel and then building a macro that pops up a Msgbox warning:

1)  It can't happen with new records - it can only occur when the user goes back and makes a change to an existing record with the "Qty" and "Mfg Part Number" fields already filled out
2)  They want the pop-up warning box to say "Are you sure you want to make changes". (Y)es and (N)o keyboard stroke must work in conjunction with the warning box. (Y)es would allow the user to continue to the next field or record.....(N)o would just stay in the field

My utmost appreciation to anybody who can make this work, and explain generally how to apply it to the field.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial