[AccessD] Checkbox/Combo box questions

I have a group of several checkboxes, all selecting members of the same
table; this is the type of information that would usually be represented in
a multi-select combo box, but the boss wanted it to be in this format.

When a checkbox is clicked to add a checkmark, I need a combo box to come
up, showing options available (from another table) to that particular
checkbox. I need to save the choice (if any), and then allow the user to
select another checkbox and go through the process again. Of course, I need
the information to be captured.

Let’s say we have 3 families: The Smiths, Joneses, and Browns. Here are
their members:

Smith: Sam, Sally, Sue
Jones: John, Joan, Jim
Brown: Bob, Barb, Bill, Brenda

If checkboxes are labeled with last names, and the user checks Smith, I
want the combo box to display Sam, Sally, and Sue, so that the user can
choose one of them; let’s say Sam. The user can then select Jones or Brown,
and have the appropriate first names show up; let’s assume it’s Barb Brown.
When it’s finished, I should have Sam Smith and Barb Brown available to be
inserted into the database as the choices for this iteration. Families
(last names) and individuals (first names) are in different tables, with
the individuals table having a secondary key to the families table.

I have the checkboxes; I can create the combo box. I’d like to use the same
combo box for all choices and repopulate it based on the checkbox choice;
otherwise, the combo boxes would take up way too much room (I have over 30
checkboxes). Also, I’m not really sure how to capture the information,
since reusing the combo box would disallow just capturing the data when the
user is finished (previous choices would have been deleted).

Any suggestions?

TIA,

Tom Ewald

This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information.  No one else may read, print, store, copy, forward or act in reliance on it or its attachments.  If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.