check box on subform

S

steve

I have a subform (datasheet view) with a check box for one of the fields.
How can I allow the user to only check true to one of the subform's records?

In other words, if the first record is checked, then the user checks the
second record, I want the first record to be unchecked.

Each record for the main form will only have one subform record where this
checkbox = true.

thanks,
steve
 
Top