List of authorized approvers

[Robert_DubYa]

I want to create a check box that will allow just a list of authorized users
(saved as a table) to check or uncheck a check box. I know how to grab the
user ID off the network, but what would be the best way to check this against
a table. I just don't know how to pass each individual record from the table
into a variable (the remainder I know how to do).

thanks,
Robert

 

[pietlinden]

I want to create a check box that will allow just a list of authorized users
(saved as a table) to check or uncheck a check box.  I know how to grabthe
user ID off the network, but what would be the best way to check this against
a table.  I just don't know how to pass each individual record from thetable
into a variable (the remainder I know how to do).

thanks,
Robert

You'd have to put code in the OnCurrent event of the form to enable/
disable the checkbox based on the user's existence in the authorized
user table.

You could use DCount() to determine the user's existence (it should
return 1 or 0), and then just set the enabled property of the control
to that.

OnCurrent()
Me.Controls("SomeCheckBox").Enabled = DCount(...)

It's totally a cheat, but 0 evaluates to false and anything else to
True...