display control does not lend to desired form control

[Amanda Byrne]

I have a People table that tracks individuals involved with our organization.
I have an Interest table that contains the various interests people might
have (and categorizes those interests). Then I have an AccountInterest table
that pairs the people ID with the interest ID.

On my People form, I want to have an Account Interest subform with
checkboxes for the different interest fields, but on the data side of
things,these checkboxes are going to be adding and deleting records in the
Account Interest table.

Could someone suggest the simplest way to accomplish this?

Thanks (again), Amanda

 

[Marshall Barton]

I have a People table that tracks individuals involved with our organization.
I have an Interest table that contains the various interests people might
have (and categorizes those interests). Then I have an AccountInterest table
that pairs the people ID with the interest ID.

On my People form, I want to have an Account Interest subform with
checkboxes for the different interest fields, but on the data side of
things,these checkboxes are going to be adding and deleting records in the
Account Interest table.

Could someone suggest the simplest way to accomplish this?

This kind of thing is commonly done by using a continuous
subform with a combo box to select the interest.

Your use of check boxes makes for what in my opinion is a
clumsy UI (not to mention all the work you're concerned
about). An especially important factor is what do you do
when you need to add a new interest, change the form's
design??

 

[Amanda Byrne]

Sure, I could use a combo box, but that still doesn't solve the problem of
adding/deleting entries every time they're selected and deselected.

- Amanda

 

[Marshall Barton]

In a continuous subform bound to the Interests table, adding
an entry is just a matter of selecting an entry in the new
record's combo box.

You may want a command button to delete the current record,
but the code behind the button is simply:
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRcord