Option Group - Question

  • Thread starter Russ via AccessMonster.com
  • Start date
R

Russ via AccessMonster.com

Hello,
I have an option group with options of monday, tuesday, wednesday.....
What do I need to change in the properties to be able to click more then one
option?
Say monday and wednesday?

Thanks
 
O

Ofer

Create option without the group.
An option group can eccept only one value, so you can't select two options
The other option that you have is to create a list box with multi select.
 
R

Russ via AccessMonster.com

Please exlain; Create option without the group
What are you refering to, how do you do it?
Create option without the group.
An option group can eccept only one value, so you can't select two options
The other option that you have is to create a list box with multi select.
Hello,
I have an option group with options of monday, tuesday, wednesday.....
Click to expand...
[quoted text clipped - 3 lines]
Thanks
Click to expand...
Click to expand...
 
J

John Vinson

Hello,
I have an option group with options of monday, tuesday, wednesday.....
What do I need to change in the properties to be able to click more then one
option?
Say monday and wednesday?

Thanks
Click to expand...

You cannot do this with an option group. An option group control has
one and only one value; that's how it's designed to work.

What are you trying to accomplish? What will you DO with the values
Monday and Wednesday once they're selected?

John W. Vinson[MVP]
 
R

Russ via AccessMonster.com

Ok, I get it.
So need check nox for mon, tues ...
Just storing true or false in a table for now.

John said:
Hello,
I have an option group with options of monday, tuesday, wednesday.....
Click to expand...
[quoted text clipped - 3 lines]
Thanks
Click to expand...

You cannot do this with an option group. An option group control has
one and only one value; that's how it's designed to work.

What are you trying to accomplish? What will you DO with the values
Monday and Wednesday once they're selected?

John W. Vinson[MVP]
Click to expand...
 
J

John Vinson

Ok, I get it.
So need check nox for mon, tues ...
Just storing true or false in a table for now.
Click to expand...

Then STOP.

You're apparently starting the process from the wrong end: the form.
Designing a table to fit your form is like building a house starting
with the windowframes, and then figuring out where to put the
foundation.

If you have fields named Monday, Tuesday, etc. your table structure IS
WRONG.

If you have a one (entity) to many (date) relationship, build your
tables (two of them, at least) to reflect that relationship... and
THEN design the form to fit the tables, rather than vice versa.

John W. Vinson[MVP]
 
Top