Create Report From Multilist Check Boxes, Access 2010

[AndyC121]

I have uploaded a small part of my database. I want to be able to make selections in my drop down list but then generate a report from the selections and have this shown in the relevant/corresponding boxes as ticks or crosses in my report. my report will be similar to report1 but with the relevant boxes ticked from selections made in the cosh table. any idea's or pointer to doing this? thanks

[June7]

This is normally done with a listbox. Review: http://allenbrowne.com/ser-50.html

The listbox must be UNBOUND, unlike your combobox which is bound to field.

You can either use the image as a background for the report and put data controls (textboxes and checkboxex) on top or replicate the paper form with textbox, checkbox, label, line controls.

[AndyC121]

I came up with a cross tab query

TRANSFORM Count([COSHH table].ID) AS CountOfID
SELECT [COSHH table].ID
FROM [COSHH table] RIGHT JOIN Hazards ON [COSHH table].Hazards.Value = Hazards.ID
GROUP BY [COSHH table].ID
PIVOT Hazards.Hazards;

seems to do what I need...just a long way around as I have multiple lists on my real form

[June7]

Glad you have solution. Think I misunderstood your requirement and what you meant by 'generate a report from the selections'.