Can You lock a checkbox control per record

[Guest]

I would like to turn off only the check box controls that have already been
selected.

I have a multi-row data sheet subform that I use to select multiple records.
However if the some of the rows have already been selected I would like them
to appear greyed out.

This seems like it should be easy. If I loop through a recordset can I turn
off just the rows returned by my query?

Thanks for the help. Time for bed.

 

[John Spencer]

You could use conditional formatting and an expression that checks the value
of the checkbox. If you want to grey out all the controls in the row, then
you would have to apply the conditional formatting to each of the controls.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..