VBA for Access

[Ian@1904]

As I am between contracts I am back on teaching myself the basics of VBA.
BTW I am using Access VBA for Dummies and the Microsoft Running MS Access books.

I understand the basics to set the properties for a control e.g.
Private Sub ccc_AfterUpdate()
objectname1.BackColor = vbGreen
End Sub

How can I set the properties so that on opening a form for several controls eg objectname1, objectname2, objectname3 I can set all to vbgreen without repeating all the code for each control. I think I need to create a class object but what code to enter in there?

[RonProwse]

you need to do a for each loop over the controls in the form then test each one to see if it is of type button then you can set the property

[wilbo]

Originally Posted by RonProwse

you need to do a for each loop over the controls in the form then test each one to see if it is of type button then you can set the property

what he said..

you loop through the controls collection testing for type objectname1 etc and call your AfterUpdate code..

(got slightly confused momentarily by your use of the word 'properties' )