A2K Listbox Rowsource question

[James]

Hello,
This is a bit complicated but the bottom line is this:
I have a form, class, and 'wrapper' function in an MDE that I have
listed in my References. (The 'wrapper' is to enable referring to the
class from another database that References the MDE.)

The form has a listbox object whose Rowsource I set to an SQL string
that I pass as a parameter to the wrapper. Here is my problem: once
displayed, the list box appears empty (as though the SQL produces an
empty set). However, if I stop the code, examine the SQL string, cut
and paste it into a query it produces the correct results. There are
On Error conditions set to trap errors but none ever fire. Initially I
thought the reason was that code executing in the MDE would not be
able to determine what database the tables I was referring to in the
SQL were in so I constructed the string in such a way as to include
the full table identification ([database].[tablename]). Again, the SQL
works perfectly in the query builder when pasted in as a string.

If I move the form and class into the current database everything
works as I would expect.

Any ideas as to why this is behaving this way would go a long way to
restoring my sanity (but sadly, it would probably not restore it
completely...)
TIA
James