how to reference one object on a continuous form

[Leo J]

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.

 

[jwindon]

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

 

[FlashG]

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