select desired labels to print in a report

[pOcean]

Hi everyone.
I have a very general question that needs your help.
I am trying to design a form so that the user can select the field that they want to view on a report.
for example, the report has fields like name, address, phone number, and etc.
i am trying to design a form so that the user can decide if they want to print the whole thing, or just what have been selected such as "name and address", or "only phone number".
I know this is going to be a very general question.
But can someone give me some general clues of what to do?
Thank you.

Sincerely

Gary

 

[jtvcs]

You could use checkboxes on the form, then build the SQL statement to pick up the correct data for the report. To see how to build the SQL statement, build a Query (in design view) and look at the SQL 'behind the query' (see View menu item). This will help you discover the SQL code necessary for the different variations the user might pick. HTH JT