Selective Fields in Reports

[rmakings]

Hi - definitely new at Access here - so bear with me. I need a way to perform a search from a form to write to a report. I have accomplished this using a query. From the same form I need to be able to select which fields are displayed on the report. I have no idea how to do this. I also need to be able to choose what format the report is going to display (Columnar, Tabular, etc.) Any help would be greatly appreciated. Thanks

 

[dhookom]

Your request is to basically re-write the Access report wizard. I have been working with Access professionally for about 10 years and would not attempt to do this.

I am wondering what is behind this request. Most of what you are asking for can be done with the query by form "applet" available at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]