Selecting only one checkbox

[RobInAZ]

My database has a section that lists a bunch of street address in a continuous form. A user needs to select one address (via a check box) and then click a command button to move on. The problem is that a user can by mistake select two or more addresses and click the command button. If two or more addresses are selected the ultimate report that is printed is inaccurate. How do I force the user to select only one address or alert the user that they must select only one before moving on.

Thank you,
Rob

 

[Rich]

Change the multi select option on the property sheet?

 

[RobInAZ]

Rich,
I looked all over for the multi select option. Can you give me some directions. I am using Access 2000.

Thank you,
Rob