Control the User's Mouse Movement

  • Thread starter Thread starter Joy M
  • Start date Start date
J

Joy M

Hi -

I would like the controls on my form to be filled in, in a specific order.
Is it possible to control the user's mouse movement on a form? Is it a good
idea?

I would like the user to pick from the first, 2nd and 3rd combo boxes, in
that order.
I don't want them to be able to backtrack and change their selections, but
they could Undo the form, (to start over from the beginning).
After they pick from the 3 combo boxes, the combo boxes could be locked, and
then they can fill in the text boxes in any order.

Is it worth doing and how do I write the code?

Thanks so much for your help!

Joy
 
Joy

Rather than trying to control mouse movements, consider controlling the
controls' "Enabled" property. You could start with a single field enabled
(?first combo box). Once you can confirm that a choice has been made there,
you could enable the second, ... and so on.

If you want to prevent "backtracking", you could set already-completed
controls' Enabled property to False.

Good luck

Jeff Boyce
<Office/Access MVP>
 
Thanks for the quick reply, Jeff.

In which event(s) do I do the switch, i.e.disable the first combo and enable
the second one? How does setting focus work?

I want to let the user have a chance to get the first combo correct, before
I do the switch.

Thanks for helping,

Joy
 
Joy

If your first cbo has a value selected (assuming that a choice MUST be made
from the list, no new values added), it would be a "correct" value, right?

One approach might be to use the BeforeUpdate() event to check for the
presence of a value. If found, cbo2 could be enabled. When cbo2 gets the
focus (OnFocus), you know you're done with cbo1, so you could then disable
cbo1.

NOTE: this is untested -- you may need to play with it a bit.

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top