Populating Report list using checkboxes

[marcis]

Hi,



I have a database with predefined TOY description values (color, price, weight etc.).

I have a kindergarden with multiple rooms.

I need to make a report for each room with its TOY list containing also information from predefined TOY description values.

Is there a way to solve it using check boxes in a Form (where I have all the toys shown and I just put a check mark for a toy I want to be included in this room). If so, how can it be done?

Many thanks,
M.

[June7]

For a relational db structure, you need at least 3 tables: tblRooms, tblToys, tblRoomToys.

Build a form/subform: main form bound to tblRooms, subform bound to tblRoomsToys with a combobox to select toy.

Build a report with a recordsource that joins the 3 tables.

Your checkbox approach would not permit saving records without writing a bunch of code. If you don't care about saving records and you are the only user of db then can just have a yes/no field in tblToys and filter report on that field.