Code to force click on command button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pattyt - 21 May 2008 17:50 GMT

Hi All,
I thank you in advance for your time.
I have a text box with an event code on click that calculates a number based
on data entry in my main form (the user clicks the button to calculate).
Everything is working great but I would like to add code to force the user to
click the button in order to save or leave the record.

Main Form: frmQaActivity
Control Name: CalculatePoints

Any suggestions?

Reply to this Message

Maurice - 22 May 2008 08:06 GMT

How about using the before update of the form.

Private Sub Form_BeforeUpdate(Cancel As Integer)
'if you want the user prompted:
msgbox ("Click save button first", vbOkOnly)

'or if you want to automate this call the CalculatePoints sub from here:

CalculatePoints
End Sub

hth

Signature

Maurice Ausum

> Hi All,
> I thank you in advance for your time.
[quoted text clipped - 7 lines]
>
> Any suggestions?

Reply to this Message