Hiding buttons

[dulux]

Hi all,

I have a button that performs a script that can only be run once per record. Is there a way of reading a field in the table that stores whether the script has been run and then hiding the button so that it cannot be run again?

many thanks

Rich

[mr_vodka]

You will need to set a field with a flag indicating that it has been run for it. I would just set it with the record's Primary Key so it will be easier for you when you create the self join using this technique.

Visibility

[Fitch]

You might achieve a similar effect by dimming the button's text (assuming it's a text button and not a graphic) using conditional formatting.

The button's script can throw a dialog and exit if the flag field has been set.