Help Needed regarding Record Source

[IcePak]

Hi,

This may not apply directly to this forum, but I didn't get a solution in the other forum and you guys and gals are usually right on.

I have a report that has a subreport in it. The report displays a
picture and one row of data. The subreport in the report will
display information from a table depending on the content of one
of the cells in the row of data displayed.

Is there any way to have the record source of the subreport call out
a table where the table name is obtained from
referencing a cell from a row of data?

Something along the lines of how queries call out form variables
[Form]![Formname![VARIABLE]

I tried doing something like SELECT DISTINCTROW
[[Form]![Formname]![VARIABLE]] but it gave me a syntax error

Also, if you have a solution, is it possible to do a similar thing to choose which picture to display?

Any help would be grand

-mike