Option Group on a Form

  • Thread starter Thread starter n
  • Start date Start date
N

n

Hello,

I have two questions:

Q1.
I am trying to create an option group where one can choose
from 8 different options and is allowed to only select up
to three of those options. How do you allow it to pick up
to three options?

Q2.
My option group looks something like the following:
A- B- C-

etc. where each of the letters has a check box by it. If I
am trying to make each letter represent a message that
will pop up later in a report how can go about doing that?

Thank you,
n
 
n said:
Hello,

I have two questions:

Q1.
I am trying to create an option group where one can choose
from 8 different options and is allowed to only select up
to three of those options. How do you allow it to pick up
to three options?
Click to expand...

Sorry, an OptionGroup only allows one selection because it has to return a
single value to the underlying table field. What would the value be if you
selected more than one?

You could have CheckBoxes individually tied to separate fields in the
table, but that would be non-normalized and would be difficult to limit the
selections to only three.

Sounds like maybe you need a related table instead.
 
Back
Top