I have a form in datasheet view. The objects on the form are either textboxes or checkboxes. If a particular checkbox on a row(record) is checked, I would like to disable some of the objects on that same row, so the user cannot enter data there and see that he cannot. Do you know of a way to reference i.e. change the attributes in one occurrence of the object instead of all of them, i.e. effect the whole column.

If you go into design view, you can add code to If-Then on these objects. I did something similar on a datasheet view form.

On the OnCurrentEvent for the form. (Therefore the code fires on each record (ROW) as the user moves record to record.

If CheckBox = Yes Then
Me.Name.Enabled = True
Else
Me.Name.Enabled = False
End If

what does 'me' refer to? The name of the form or of the table?