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

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.