Hi All!
I'm trying to create a report generator. I've got it to where it will create the report and set the record source and open it in design view. What I need to be able to do now is add the fields from the record source into the report detail section. The vba help doesn't help much on this one.

Can anyone help?

Thanks in advance!

dartcoach

__________________
dartcoach

Question: Do you know which recordsource you are always going to have with this report generator? If so, you can do something like add unbound text boxes to your report, and then bind them at runtime. You can do this in the report detail's On Format event.

Perhaps you should discover the fields in a macro.

If you don't know the recordsource ahead of time, or if they are similar, you can still drop the text boxes on, then discover the field names with code and bind them that way. Like this:

   rs.Fields.Name(0) might give you the PK's field name. I know there is syntax for this. Then you can make the the label's text using code, etc.

HTH or gets you started.

mmcdonal

Michael,

Sorry I didn't put another post on this one. I got the createreportcontrol command to work. What I have is a form that populates a listbox with all the tables in the current database. After picking a table - it populates another listbox with the columns in that table. This listbox is multiselect - so when I pick the columns I want on my report, it populates yet another listbox to allow me to sort by one of the fields I've selected for my report. After all that, I have a text box for a report title, then a command button to generate the report. The recordsource is generated, and within a loop, I create a textbox for each column, then open the report. It works great! The only issue is - since the user can pick as many fields as they want from the table, formatting the report to fit is quite an problem. I took the easy way out, I created a shortcut menu to allow the user to analyze with excel. That way they can format the report anyway they want to.

Thanks for your help!

Kevin

dartcoach