I have a form that enables users to input data to a certain number of tick box fields, i then have a query that collates 5 tables into one. I now need to have create a form which has all the fields used previously blank, still as tick boxes mark off the ones you need then it needs to produce a report of all the fields that have the same boxes marked.

ie.

I have a table with all makes of car
i have another table with all colours
then anonether with all tyre sizes

i run a query that links the makes of car id all together and gives me a list of all the cars that have the colours and tyre sizes together.

I now need to run another form that alows me to choose the tick boxes i want and produce a report for all data that matches.

Please help

ta

Hi,
  To use in this query

 select a.car_fieldname, b.color_fieldname, c.tyres_fieldname from car a , color b , tyre c where a,carid = b.carid and b.car_id=c.carid


if carid is primary key/ common field for all table

Regards
Arasu. S