Conditional visible button on continuous forms

[DerekMcDonald]

I've seen a lot of questions on conditional text formatting, which I understand... But here's one on conditional formatting buttons within continuous forms.

I have continuous subforms within a main form, showing up as rows. Within each subform/row, I'd like a button cmdGoTo to be visible only where the value of a combo box in that subform is "Workshop". Of course, if I try to set the visible property of the button using the "current" or "load" events, when the button becomes visible on one subform it becomes visible on all the subforms.

There must be a way to code around this! Anyone? Thanks!

 

[B827]

I find that using the On Double Click event is easier to use in this type of situation. You can pick up the value of the combo box and perform different actions depending on the value. Sandy