Control on Check boxes

  • Thread starter Thread starter Tim Schiermeyer
  • Start date Start date
T

Tim Schiermeyer

I wish to control the users ability to select check boxes for various
records. The idea here is I have a list of values from two different
database I am comparing. At the point were the user inputs the data (check
boxes) the database has determine which values have errored. Now it is up to
the user to use one of the values list since they are different from one
another. Want I need is to block out the check boxes where the value have
not errored, ie the user can not select these boxes.
Thanks
Tim Schiermeyer
 
I'm not sure I completely understand you question, but
once you know which controls should not be usable, set
the enabled property to false to gray them out, or set
the visible property to false to hide them altogether.
HTH
Ben
 
Figured out how to control users ability to populate the check boxes given
some other data. Placed this piece of code in the validation field, works.
Ideally it would be nice to gray them out in the VBA code running in the
background. But this works for now.
=IIf(InStr([Rating_Errors_Full],"R1")>0,-1,0) Or
IIf(InStr([Rating_Errors_Full],"R1")>0,0,0)
Thanks for you ideas, I think I will implement them later.
Tim
 
Back
Top