Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create a report in VBA and to put fields?

Status
Not open for further replies.

jondion80

Programmer
Jun 21, 2002
7
0
0
CA
Hi everybody. I got a question. I'm trying to create a report in VBA. I want to determinate the fields, but the fields depend on a selection. If I have [C-NAME] and [C-FAX], I just want those two informations and nothing else.


Set myReport= Reports.Application.CreateReport(CurrentDb)

How can I put a correct SQL line in a "new" report, that will contain or will show just fields I need? Thanks for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top