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

Do you mean check boxes?

You can create queries and then pass parameters to the check mark fields as "Yes" or "No", or in some databases TRUE/FALSE, or 0/-1 etc. Depends on the database.

I am not sure what else you want.

mmcdonal