Referring to a particular record on a subform

[Remster]

Folks

The attached is a screenshot of a subform in Continuous Forms view. It contains a combo box, a check box and a navigation button. I want the check box and the navigation button to be disabled for any record where the value of the combo box is null. How do I achieve this? I've tried the subform's On Current event, but what happens is that if I click in the combo box with the value that is null, both records' check boxes and navigations are disabled, and if I click in the combo box with the value that isn't null, both records' check boxes and navigation buttons are enabled.

Thanks



Remster

[apr pillai]

The User can work with only one record at a time. So the status change on the other records (when you lock a control/field on the data sheet view all controls on that column will be locked) doesn't make any difference to the user.

[Remster]

The problem was one of appearance (the formatting of disabled fields is different from the formatting of enabled fields) but I've got round it by using locking instead of disabling. Thanks for your input.