View Single Post
  #1  
Old May 15th, 2010, 05:39 PM posted to microsoft.public.access.reports
jpm[_3_]
external usenet poster
 
Posts: 11
Default Dynamically Add fields/controls to reports

Hello,

I've not much experience with building reports in MsAccess. Can one
dynamicall add fields/controls to reports from a vba module such as that
linked to a form? i.e. do processing . . .set a sql string as a report's
recordsource, then have the fields of the recordsource added or displayed in
the report. I want to do this without having predefined the report
content/format, etc. Can someone give me information or point me to
information on this?

Part of my reason for persuing this data display method is that there
doesn't seem to be a grid control for displaying data on a form. So, how
about a report that is built dynamically; can I do that?

Thanks for any help,

Jim M.