checkboxes in subforms

[bhakta.ram]

Hello All:

I have a incident table, action_taken table and incident_action_taken
table.

incident table
-------------------
iid(PK)
name
desc

action_taken table
-------------------------
aid(PK)
name
desc

incident_action_taken
-------------------------------
id(PK)
aid
iid

I have a main form and a sub form. Main form shows incident table and
subform shows incident_action_taken table. I want to show all the
"action_taken.name" field as a checkbox in the subform. I had a
"yes/no" column in incident_action_taken table but did not help.

I would appreciate if somebody can help me on this.

Thanks

 

[Guest]

If I understand you correctly, you want the user to select the action taken
from a series of checkboxes. Is this right? In Access, the only standard way
to expose checkboxes in in a form. You cannot do it from within a ListBox or
ComboBox.

The simplest way to accomlish this is to use a ListBox instead of
checkboxes. If you're set on using checkboxes, you'll need to create an
unbound form that reads your action_taken table. Drop this form into your
existing subform as a subform. Then you'll need to pass the value selected
back through the Child/Master properties or though code.

Barry

 

[Guest]

And, by the way, please don't multi-post:
http://www.mvps.org/access/netiquette.htm#Asking

This wastes people's time.

Barry