Help Please.
I have a continuous form with various fields showing together with a command button all in one line.
One of the fields is Yes/No and if it is Yes, I would like to hide the command button, whilst if it is No I would like to show the command button.
Using vba, how can I achieve that?
I believe the vba code should be an If, Else, End If statement and the relevant vba should be cmdbtnname.visible = False or True, but on which event should I insert that vba code so that when the form displays only those lines where the command button should be visible display the command button.
Many thanks

---

Reply from Rick Rost:

David, you really can't do this with VBA code, as surprising as it sounds. If you make the button invisible or disabled, you assign those attributes to ALL of the buttons on that form.

There is a trick where you can use an unbound text box and CONDITIONAL FORMATTING with an EXPRESSION to look at another value in the record, and then disable the text box accordingly. You can make the text box LOOK like a button and then use an OnClick event to handle what you want there.

See if that works for you. If you can't figure it out, let me know. Maybe I can include this in an upcoming video.