Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting data from a query to check boxes on report

Status
Not open for further replies.

dbar10

Programmer
Dec 5, 2008
196
US
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
 
Sometimes I get too close to the forest to see the trees. I figured this one out. thanks anyway.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top