Hi,
I want to add a message box (vbYesNo) and am unsure of the code to use. I want the message to read 'Are you sure you want to close this record?' and if Yes is clicked I want the current record to become either locked or all the controls disabled (but no other records) and if No is clicked just to return to the form.
Does anyone have any ideas?
Many thanks in advance,
Kirsty.
I want to add a message box (vbYesNo) and am unsure of the code to use. I want the message to read 'Are you sure you want to close this record?' and if Yes is clicked I want the current record to become either locked or all the controls disabled (but no other records) and if No is clicked just to return to the form.
Does anyone have any ideas?
Many thanks in advance,
Kirsty.