Hi Shaun,

The On_Change should be On_Current, my mistake sorry. But you are correct
when stating that in an option group you only can select one item. So this
option is no good for you.

The tags...

Every control has a tag. It's a property where normally nothing is stored
but you can use it. Because you can use it many people do.
So for instance: a textbox has properties (i assume you know how to get
there but just to be sure - rightclick on control in designview and choose
properties)

Now look for the option 'Tag'. I have to say that this is the English word
for it. Depending on your Office lanuguage this might differ. (if you check
the 'other'-tab it is at the bottom).

What you can do is place the word 'chk' (without the quotes) in the tag of
every checkbox.

Now in code write the following for the form:

private sub Form_AfterUpdate
dim ctl as control

'-> Loop through controls

for each ctl in me
 if ctl.tag ="chk" then '-> check to see if there's something in the tag
   [do your action here...]
 end if
next

end sub

hth