UserLevel Security Question

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I have User Level Security setup on one of my database
applications. Certain forms are not accessible to some
users, and in some forms, certain features are not
available to some users. This is all working pretty well,
but I have one form with an option group with 3 radio
buttons. Certain users can only use one feature associated
with this option group. The option group allows the user
to print reports. Some of the reports are not accesible to
certain users. On each of the readiobuttons, I have VBA
code behind the OnGot Focus event. This code does what I
want and everything works pretty well. When users open the
form who are not allowed to access certain reports, the
option group is set to 1. This radibutton allows them to
print the only report on this form that they have open to
them. The oproblem I am having, is that the OnGot Focus
event still fires if the user clicks on this radiobutton.
The Oprtion group is locked so the value of the option
group does not change, but that code still runs and is
causeing a problem.

Wheeeeeuuuuu!

Any suggestions?

Kevin
 
Locking a control does not prevent the focus moving to it. So, GotFocus is
correct to fire then.
Disabling< a control prevents the focus moving to it. Perhaps try that.
Click to expand...

Or, in GotFocus, just see if the control is Locked. If it is, you know to
ignore it.

HTH,
TC
 
Back
Top