[AccessD] Make Multiple Selections on a Form and Create a Recordfor Each

Hi Drew,
No, I'm not at all averse to using it - I just don't know much about how 
to.  Would you care to expand on the subject?
Tina

Drew Wutka wrote:
> Tina, are you averse to using a treeview control?
>
> Drew
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> tinanfields at torchlake.com
> Sent: Friday, February 27, 2009 12:22 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Make Multiple Selections on a Form and Create a
> Recordfor Each
>
> I hope the subject line isn't too confusing :)
>
> Here's the situation:  volunteers fill out a paper form indicating which
> skills they have and at 
> what level (1 to 3, with 1 being high).  When this database was built
> (1999), the developer crafted 
> a macro that added one record for every possible skill (32, so far) to
> the table of volunteers and 
> skills.  The data-entry person then went down the rows, clicking the
> ones that were to be selected, 
> and entering the skill level number.  This results in lots of empty
> records.  Since then, the 
> database crashed and the macro no longer works anyway.
>
> I want to craft a form with a checkbox for each skill and a drop-list of
> the skill-levels, so the 
> data-entry person can click the checkbox and select the skill level -
> then click a button that will 
> place one record for each skill selected into the table of volunteers
> and skills.  This gives the 
> data entry person the same ease of entry, but does not create lots of
> empty records.  I saw 
> something in the ADH that captures the number of selections made, and
> I'm guessing I need to start 
> there, but I could sure use some inspiration on this.  If three skills
> are checked, I want three 
> records entered for that volunteer in the volunteers and skills table -
> each one referencing one of 
> the selected skills.  
>
> Thanks for any ideas.
>
> Tina
>
>
>