Been a while since I took a stab at vba and access, but I have a simple problem.
I have an option group with 6 buttons, when one is pressed I'd like to bold and set the text color to red.
I realise I could use if or case to nest all 6 possible senarios, but seems needlessly messy. Such as this.
Select Case optPlant
btn1.ForeColor = 255
btn2.ForeColor = 0
What would seem ideal would be to call a for next loop to loop through all the toggle button options in the frame. Something like this, I just don't know the correct syntax for the controls under an option frame. Just seems like that would be cleaner since adding more buttons just gets really messy with the case way.
for each btn in optPlant.buttons
if btn = pressed then
btn.forecolor = 0