How do I create radio buttons in an Access form?

[Guest]

Please speak slowly and use small words in replying.

I think want to create radio buttons in my form in Access. Some questions
will look like this:

What sorts of classes would you be most interested in taking?

___ Rowing ___Skiing ___Swimming

If someone wants to pick all three, then I want to be able to collect that.

How do I do that in Access forms? I have not yet created my Table in Access,
because I cannot figure out how to create the field for a radio button.

Thanks,

Andrea

 

[Douglas J Steele]

Officially, radio buttons are intended only for situations where a single
value is selected. When you want to select multiple options, you're supposed
to use check boxes.

While I'm at it, you cannot use an Option Group and have it return multiple
values.

It sounds as though what you're trying to do is resolve a many-to-many
relationship between users and classes (one user can take many classes, one
class can be attended by many users). Typically what's done in such a
situation is create a third table to resolve the many-to-many relationship.

If you take a look at the Northwind database that comes with Access, you can
see an example of this. There's a many-to-many relationship between Products
and Orders (one order can contain many products, one product can be part of
many orders). The table Order Details resolves this many-to-many
relationship. The usual approach for allowing input of the information is to
use a form and subform. In Northwind, the two forms are Orders and Orders
Subform.

 

[Guest]

Thank you Doug. I will look at the Northwind Database - you've given me a
direction to go in.

Regards,

Andrea

 

[Douglas J Steele]

You might also take a look at the "Select Records" example Sandra Daigle has
at http://www.daiglenet.com/MSAccess.htm

It's a simpler interface. (Unfortunately, it's not really intuitive what
Sandra's doing there. If you're just at the Getting Started stage, it may be
a little hard to follow)

 

[Guest]

I will study this. It is a little beyond my understanding at the moment, and
I thank you for your time.

REgards,

Andrea