Access 2000 VBA programming help

[stuartam]

Can someone shed some light on how I might achieve this ( ive got quite a few books now, but I cant work it out ).

I have a form with the following:

a combo box containing a list of users
4 check box’s ( will be adding more in time )

When the user checks the 1st check box it stores there user name in one field in the table, then the user check’s the 2nd check box it stores there user name in a different field in the table, and so on.

Eventually I also want to be able to add the ability to story the date / time that the check box was checked for each of the check box’s (now that’s not proper English is it )

Any help would be great.

Best regards

[BrianB]

This example code goes into the module for the userform. It runs when the check box changes value. :-

Private Sub CheckBox1_Change()
    '- do nothing if box is un-checked
    If CheckBox1.Value = False Then Exit Sub
    '- data to worksheet
    ActiveSheet.Range("A1").Value = "MyName"
    ActiveSheet.Range("B1").Value = Now
End Sub