Option group - how to allow only one radio to be selected

[Guest]

I saw another post very similar to this, but no solution was given.

I am creating a db that will allow the user to fill out a travel request
form where the user can choose the following:

Choose mode of transportation
Rental car [ ]
Rent at
Location1 [ ] or Location2 [ ] or Location3 [ ] Other_(user fills
in manually)_

or

Personal car [ ]

Each selection is linked to a corresponding field in a table. I want the
user to be able to select "Personal car" and not be allowed to select another
option, or select "Rental car", then select only one location, and not be
allowed to select "Personal car". The selection(s) will be saved in the
corresponding field(s) in a table. The report the table generates will show
the check mark beside the appropriate field label.

Does anyone know how to make this happen?

Thanks,
alipscomb

 

[Guest]

I would make Rental Car and Personal Car selections in an option group. In
the AfterUpdate event of the option group you can test for the user's
selection. If the user selects Rental Car make the RentalLocation field
visible (if they go back to Personal Car make the RentalLocation field
invisible). The RentalLocation field should consist of choices from a combo
box....don't make more than one field for data entry for the same data. If
the selection in the combo box is "Other", make the "Other" AlternateLocation
field visible.

The option group only stores one value.

 

[Guest]

That sounds good, in fact, after I made the post I was starting to think in
that direction.

Thanks for the advice,
Anthony

I would make Rental Car and Personal Car selections in an option group. In
the AfterUpdate event of the option group you can test for the user's
selection. If the user selects Rental Car make the RentalLocation field
visible (if they go back to Personal Car make the RentalLocation field
invisible). The RentalLocation field should consist of choices from a combo
box....don't make more than one field for data entry for the same data. If
the selection in the combo box is "Other", make the "Other" AlternateLocation
field visible.

The option group only stores one value.

I saw another post very similar to this, but no solution was given.

I am creating a db that will allow the user to fill out a travel request
form where the user can choose the following:

Choose mode of transportation
Rental car [ ]
Rent at
Location1 [ ] or Location2 [ ] or Location3 [ ] Other_(user fills
in manually)_

or

Personal car [ ]

Each selection is linked to a corresponding field in a table. I want the
user to be able to select "Personal car" and not be allowed to select another
option, or select "Rental car", then select only one location, and not be
allowed to select "Personal car". The selection(s) will be saved in the
corresponding field(s) in a table. The report the table generates will show
the check mark beside the appropriate field label.

Does anyone know how to make this happen?

Thanks,
alipscomb