I'm trying to set up an ad-hoc report system. My basic train of thought was to have a form which lets the user select a table from a combo box, once the table is selected the available fields list box is populated. The user then selects which fields they want to see on their report. I've set this form up and it works, my problem is how can set up the report so that it's fields are populated after the user selects them. So not a canned report but a report generated by code somehow. I was thinking I could use unbound text boxes in the report and them somehow refer to the forms combo box to get the table name and the the list box for the field names...any ideas would be very helpful! Thanks
Bill
Bill
