Wildcard Fields in VBA

[Dancinrain]

Personally, my question seems to be what will be an easy fix, but I can't seem to find a solid answer on how to streamline my solution. I am using Access 2010 and I have a form with about 5 checkboxes. Each of the checkboxes, if ticked, will display a number of small images. Currently I am using the below if/else statement, but as you can imagine the statement becomes rather big due to the number of images being displayed. Is there a way to set a Me.BlueLight*.Visible statement instead of individually naming the images?

Private Sub chkBlueLight_AfterUpdate()
If Me.chkBlueLight = True Then
    Me.BlueLight01.Visible = True
    Me.BlueLight02.Visible = True
    Me.BlueLight03.Visible = True
    etc...
    Me.BlueLight27.Visible = True
Else
    Me.BlueLight01.Visible = False
    Me.BlueLight02.Visible = False
    Me.BlueLight03.Visible = False
    etc...
    Me.BlueLight27.Visible = False
End If
End Sub
 

[calaxan]

is below code give you solution :

 Private Sub chkBlueLight_AfterUpdate()
dim i as integer
controlName = "BlueLight"
 
If Me.chkBlueLight = True Then  
  for i=1 to 27 step 1
    Me.Controls(controlName & Format(i, "00")).Visible = True
  next i  
Else
  for i=1 to 27 step 1
    Me.Controls(controlName & Format(i, "00")).Visible = False
  next i
End If
End Sub
 

[Dancinrain]

Yes, thank you very much! Do you happen to know a good source where I can learn the basics of VBA? My experience in this matters are typically limited to the popular functions in Excel.

[calaxan]

To be honest my source is got from search engine :) . Find the correct keyword of my problem, then search the answer from search engine.
http://bytes.com also my reference if i have some difficulties.
And I think the tips from http://allenbrowne.com/tips.html can be your source too.