Allow multiple selections in an Option Group

monty27

New member
Local time
Today, 16:48
Joined
Sep 28, 2005
Messages
6
Hello -

I have an option group on a form, that has 4 possible options. I need to allow the user to select any combination of the 4 options, to be stored in fields in another table.

By default, the option group only allows one to be selected (hence the name "option"? ;) Maybe I should proceed a different way?

Help would be appreciated!
 
Yes. Not only by default, that's the purpose of an option group.
 
When multiple selections are allowed, the checkbox is a better visual clue. In any event you need to get rid of the existing frame and the options within it. It is possible to use the option buttons individually but I don't recommend it due to their "standard" use as mutually exclusive options.

You are also getting into the realm of a 1-many situation. That means that you should probably be using a subform to allow for many entries to a child table rather than creating a repeating group in a single table.
 
Ok, option group is gone. Check boxes are in. I'd like the action of checking of one of the boxes to result in a "2" being recorded in a certain field (field name is "sample" for this example) in the associated table. Needless to say (since I'm posting this), I'm having trouble accomplishing this. How do I specify what value is recorded by the activating of a check box?

Sorry if this is terribly simple and mundane, I'm a noob.

Thanks for the help, I do appreciate it.
 
It's actually easier and makes more sense to use a combo box with the values 1,2,3 and 4 if that's the values you want stored
 
Doesn't a combo box only allow a user to select one value? They need to be able to select any combination of the four possibilities (1 through 4, inclusive).
 
Then I'd follow Pat's advice, or you could use multiselect listbox
 
You need to define more completely what you are trying to accomplish here. Checkboxes are generally used with a Boolean (Yes/No) field. A checked value being True and a unchecked value being False.

Why should the value matter if the field holds only 1 or 2 values?
 
Ok - you mean Pat's advice re: subform? Unchartered waters there, but that's ok, I'm here to learn...

What I'm specifically doing is creating a database to track patients receiving a certain type of medical intervention. There are four possible 'phases' to the intervention, and any patient can be receiving any or all of the four phases. So, patient1 could be at phase 1, while patient2 could be at phase 1 and 3, while patient3 is at 2, 3 and 4. Does that make more sense? The users of the db would like to be able to see who is in what phase at a given time. I figure capturing this info in four separate fields...never mind...just figured it out. Just set up four checkboxes, doesn't matter what they record in the table, and run the query based on "yes/no" for each of the four...

Sorry for blathering...thanks for the help and patience...

-Andrew
 
Nope that's not the way I would do it. Instead I would have a table like:

tblInterventionStatus
InterventionStatusID (Primary Key Autonumber)
PatientID (Foreign key)
Phase
StartDate
EndDate

You then create a main form bound to patient table and a subform bound to this table and linked on PatientID. When a patient starts a phase you add a record for that phase with its Start date. When the patient ends the phase you enter the End Date.

You can then run a report, grouped by phase where End Date is Null to show whihc patients are in each phase.
 
If a patient can be in only one phase at a time, we're back to the combobox which can select 1 of 4 values or the option group if you prefer. If you need to record a history of the phases, you need to go with what Scott suggested.
 

Users who are viewing this thread

Back
Top Bottom