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!