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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.