Disable mouse on form

[ADixon]

Hi all

I have an unbound form with a number of txt and cbo controls which users
fill in and VBA code automatically sends an email to a group. I'd like to
disable the mouse on this form (or not allow them to click into the controls
with the mouse) so i can force them to tab through the controls, enabling me
to run checks on the text entered for each control as they exit it. A button
then sends the email with the checked values from the controls.

Is this possible?
thx in advance

 

[Mr. B]

ADixon,

From your description of your issue, it sounds like you may just need to
write a function that will check each control for the appropriate value and
have this function called from the AfterUpdate or from the OnExit event of
each of your controls.

Normally what I do is have the button disabled that is going to perform the
action untill all required data has been provided by the user. Determining
when the user has provided all of the required data is where the function
described above comes in.

The reason for writing a function is that you only have to write your code
that does the verification of each of your controls one time and then call it
from the appropriate event of each control.

When the function determines that all required data has been provided, a
statement to enable the button is executed. Like:

Me.NameOfButton.enabled = true

HTH
Mr. B
(askdoctoraccess dot com)