I need a suggestion

[iamnu]

I would like to have a form that has...say 10 yes/no controls. These
controls will be "linked" in some manner to a table that I'll call a
"Directory", which will have up to 10 entries.

If the Directory only has 3 entries, then the rest of the yes/no
controls will not be visible.

MY QUESTION: How do I show the yes/no controls with a different
caption for each of the items in the Directory?
If I add a new Directory item and make the yes/no control visible, how
do I set the caption for this unknown (as yet) Directory name.

Thanks for the help...

 

[Arvin Meyer [MVP]]

This is poor design. Instead, build a table with 4 fields:

ID - autonumber - PK
ForeignID - Foreign key match to another table - Long integer
Identifier - Text or Long integer to identify which column
Yes/No checkbox

Now id you have 3 checkboxes, you'll have 3 rows. Use a continuous form or
datasheer to display your data.

 

[davecass]

This is poor design. Instead, build a table with 4 fields:

ID - autonumber - PK
ForeignID - Foreign key match to another table - Long integer
Identifier - Text or Long integer to identify which column
Yes/No checkbox

Now id you have 3 checkboxes, you'll have 3 rows. Use a continuous form or
datasheer to display your data.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com









- Show quoted text -

A very similar solution can be found if you allow the system to create
a switchboard for you. Then, open the resultant switchboard form and
look at the code Access created.