Carry Over Data

[dcashwell3]

How do I make a multiple selection option group in Access 2003 specific to
each record WITHOUT carring over any data to the next?

 

[John W. Vinson]

How do I make a multiple selection option group in Access 2003 specific to
each record WITHOUT carring over any data to the next?

You don't, because you can't.

An Option Group control has ONE value.

If you're trying to store multiple values in one field, change your table
design; you need a one to many relationship *to a second table*, and probably
a Subform in which to enter the data for this table.

John W. Vinson [MVP]

 

[dcashwell3]

I've already made the multiple selection option group. It's a simple cut
from an option group box and then paste back into the box. I can make
multiple selections but they carry over. So I guess that's good for
selections that need to carry over but maybe I'm going around my elbow to get
to my... Anyway Thanks!

 

[J_Goddard via AccessMonster.com]

Hi -

The reason the multiple selections carry over is probably because the option
group is an unbound control, which always "carries over" from one record to
the next. If you want to 'clear' the selections, you'll have to do it using
VBA.

John

I've already made the multiple selection option group. It's a simple cut
from an option group box and then paste back into the box. I can make
multiple selections but they carry over. So I guess that's good for
selections that need to carry over but maybe I'm going around my elbow to get
to my... Anyway Thanks!
[quoted text clipped - 8 lines]

John W. Vinson [MVP]

 

[John W. Vinson]

I've already made the multiple selection option group. It's a simple cut
from an option group box and then paste back into the box. I can make
multiple selections but they carry over. So I guess that's good for
selections that need to carry over but maybe I'm going around my elbow to get
to my... Anyway Thanks!

I think you have what LOOKS like a multiselection option group... but is
actually an empty option group frame and a set of unbound checkboxes or radio
button controls. Cutting out the controls from within an Option Group control
will do just that.

Your data isn't being stored ANYWHERE except on the form - repeating when you
move to a new record (because it's not IN the record, just on the form), lost
completely when you close the form.

Again: You're trying to store multiple values in one field (the option group's
numeric field control source); this CANNOT BE DONE.

You're also apparently assuming that data is stored in form controls rather
than in table fields. This assumption is INCORRECT.

Could you step back a bit and describe what you're trying to *accomplish*
(rather than how you are trying to accomplish it)? What does the information
on the form represent, and what do these multiple selections represent?

John W. Vinson [MVP]

 

[dcashwell3]

I'm new to Access, obviously, and I'm building a DB for our PTA. I'm trying
to check all volunteer oppourtunities that a member is interested in for each
record. It needs to be able to facilitate multiple choices in the form, seen
at a glance on the form, and be flexible enough to change daily if
neccessary. I've gotten everythig else to work but this.

 

[dcashwell3]

I think you have what LOOKS like a multiselection option group... but is
actually an empty option group frame and a set of unbound checkboxes or radio
button controls. Cutting out the controls from within an Option Group control
will do just that.

Your data isn't being stored ANYWHERE except on the form - repeating when you
move to a new record (because it's not IN the record, just on the form), lost
completely when you close the form.

Again: You're trying to store multiple values in one field (the option group's
numeric field control source); this CANNOT BE DONE.

You're also apparently assuming that data is stored in form controls rather
than in table fields. This assumption is INCORRECT.

Could you step back a bit and describe what you're trying to *accomplish*
(rather than how you are trying to accomplish it)? What does the information
on the form represent, and what do these multiple selections represent?

John W. Vinson [MVP]

 

[John W. Vinson]

I'm new to Access, obviously, and I'm building a DB for our PTA. I'm trying
to check all volunteer oppourtunities that a member is interested in for each
record. It needs to be able to facilitate multiple choices in the form, seen
at a glance on the form, and be flexible enough to change daily if
neccessary. I've gotten everythig else to work but this.

The proper way to do this involves *no* Option Group controls or checkboxes.

Instead, you need three tables:

Members
MemberID
LastName
FirstName
<other biographical data>
(I'm sure you already have this table)

VolunteerOpportunities
VolID <Primary Key, probably autonumber>
Opportunity <Text, e.g. "Hall Monitor", "Band trip chaperone", ...>

Volunteering
MemberID <link to Members>
VolID <link to VolunteerOpportunities>
<any fields relevant to THIS volunteer for THIS opportunity, e.g. prior
experience, dates available, etc.>

To enter the data on a form you would use a Form based on Members, with a
subform based on Volunteering; on this subform you would have a combo box
storing the VolID but displaying the Opportunity text.


John W. Vinson [MVP]