var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: "Before Update" follow up procedure
I am trying to protect a value in field by warning user that changing it might (not neccessarily) have negative effect on previous calculations.
I have a message box asking do you want to go ahead with the change or not. and being an amateur that I am, I have no idea what ot have in the if clauses:
Warning = MsgBox(Msg, Style, Title)
if Warning = vbYes (go ahead and change the value)
if Warning = vbNo (no, keep the old value)
Please note that just locking the field is not an option. The value must be available for update, and I need a warning.
Thanks a lot.
Before Update event procedures in Access have a Cancel property built-in (Private Sub cboMyCombo_BeforeUpdate(Cancel As Integer)) so you can 'cancel' the update if the user answers 'no' or 'cancel'.
intResponse = MsgBox strMessage, etc..
if intResponse = vbNo then Cancel = True
That should be all you have to do unless there is something I misunderstood.