I have searched everywhere I can think of to get ideas on this one. I have a government report that I am using Access to complete. The form that the user enters choices on has a number of sections where the user must make multiple choices out of a table of possibilities. I then need to take those choices and display the results in matching check boxes on the report. I have worked on a number of different options with no success, short of adding about 60 fields to the parent table. The query that holds the choices the user have selected is like the example below:
SELECT POCFunctionalLimitations.POCID, POCFunctionalLimitations.FuncLimID, POCFunctionalLimitations.Limitations, POCFunctionalLimitations.[Select]
FROM POCFunctionalLimitations
WHERE (((POCFunctionalLimitations.POCID)=[Forms]![POC Form]![POCID]));
Can I have the check boxes on the report fill in based on this or something similar or do I have to build a subreport for each choice? Please help. Thanks
SELECT POCFunctionalLimitations.POCID, POCFunctionalLimitations.FuncLimID, POCFunctionalLimitations.Limitations, POCFunctionalLimitations.[Select]
FROM POCFunctionalLimitations
WHERE (((POCFunctionalLimitations.POCID)=[Forms]![POC Form]![POCID]));
Can I have the check boxes on the report fill in based on this or something similar or do I have to build a subreport for each choice? Please help. Thanks