Create report from variable selections on form

[bobsyeruncle]

Hi again,

I have a table with fields such as name, address, postcode, phone etcetc.

I haven't created a form yet as i am unsure of the best method. The end result i want is a form which can be clicked on and the user can select either 1 field or up to all 6 fields depending on which inf they require.

The fields required would then appear on the report.

I am assuming this needs to be done using a query and setting criteria on the query. If so what should i use on the form? Option groups? Combo Boxes?

Thanks for your help.

 

[bobsyeruncle]

Anyone?

 

[Mattster]

Depending on how you would like to do this, it is potential to put a click box above each item, therefore they select this checkbox for which fields they want. I am unclear how you would like the report to display, if it is in column method this will not work, but it should work, if you are just trying to display the info, parsed by commas or something.
then have your query based on these options. If checkbox1 = true then Name.visible true else Name.visible False