Set caption and back color of a buttom using VBA in another button

[markzaal]

Access 2010

Hi,

How can I set the caption and backcolor (both predefined) of a certain button on a form by clicking a button on a different form?
On the "fill-in" form I have a "finished" button. When I click this, I want the button on the main form that I use to get to the fill-in form to turn green and say "finished".
Before I used a macro with the SetProperty function but that sometimes does not work. Besides that, I am getting the hang of VBA now and want to use this as much as possible.

Many thanks!

Mark

 

[gemma-the-husky]

buttonname.caption = whatever

you can change the text color (forecolor) but not the backcolor of a button

you could use a label though, as labels are clickable, in the same way as a button, and have a backcolor for the label.