Set button Visibility

R

Ripper

There is a button that won't need to be pushed until a specific date each
year. It will go off from time to time as well.

I would like to have it's visibily be an option for administrators. Is
there a way to make the button visible/invisible via a check box on another
form?
 
B

Brian

Create a table called "Settings". Ensure you have a Yes/No field called
"YourButtonVisible". Create a form bound to the Settings table with a
checkbox bound to that field.

Now, on the form with the button, set the Visible property of the button to:

=DLookup("[YourButtonVisible]","[Settings]")

This way, every time the form is opened, the button's visibility will depend
 
R

Ripper

THANKS! Worked like a charm.
--

Rip


Brian said:
Create a table called "Settings". Ensure you have a Yes/No field called
"YourButtonVisible". Create a form bound to the Settings table with a
checkbox bound to that field.

Now, on the form with the button, set the Visible property of the button to:

=DLookup("[YourButtonVisible]","[Settings]")

This way, every time the form is opened, the button's visibility will depend
There is a button that won't need to be pushed until a specific date each
year. It will go off from time to time as well.

I would like to have it's visibily be an option for administrators. Is
there a way to make the button visible/invisible via a check box on another
form?
Click to expand...
Click to expand...
 
Top