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

 

[Pat Hartman]

You will need to delete the checkboxes from the form. Then add an option group control and re-add the checkboxes within the option group control. However, Windows interface standards would call for option buttons to be used in this case rather than checkboxes. Checkboxes are normally used when multiple options may be selected.

If you have defined multiple columns to hold this data in your table, the problem is bigger because using an option group would require a table change. Instead of having some number of yes/no fields, you would have a single field with a value range of 1-n. Proper table design dictates a single code field to hold mutually exclusive values, not a series of fields one of which contains a true value.