Set button Visibility

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
Back
Top