datasheets

Im using a access datasheet and the data is built dynamically. I have a check box option that shows up for each record displayed. I only want the user to have one option checked at a time. So if they check one box I have to clear out all other boxes first. I cant seem to reference any other check box than the one that is selected. Is this possible?

Yes, switch the checkboxes out with option buttons.

I tried that but the option buttons are still treated as independant items on each row, so i am able to check multiple option buttons. Unless im not setting something on the option buttton control.

Put the option buttons in a frame.