Storing an object in a table

[Paul H]

I have a table of report names, each of which contain at least one chart. These populate a combo box on my form. There are several other properties, like the Report ID, Access report name, underlying query and the name of the chart object. I have a Select Case statement that sets an object variable to the chart object.

     Select Case intReport
        Case 1
                            Set chrt = Reports!MyReport!grph_1
        Case 2
                            Set chrt = Reports!MyReport!grph_2
        Case 3
                            Set chrt = Reports!MyReport!grph_3

The code above works. What I would like it to do is select the chart from the column in my combo box that has that chart name, like this.

    Set chrt = Forms!frm_Chart!cboReports.Column(7)

The problem is that this is stored as text and the Set statement requires an object. Is there any way I can convert my string into an object?

[June7]

The combobox is a variable. Use parens with variables. Like:

Reports!MyReport(Forms!frmChart!cboReports.Column( 7))

[Paul H]

Thanks, that was a new one. Worked like a charm!