David,

Thanks for your post, I wasn't aware to the fact that it's possible, I think
it might solve my problem.

Thanks,
Orna.

"David W. Fenton" wrote:

=?Utf-8?B?T3JuYQ==?= wrote in
:

As I mentioned in my previuos post, the reason why I don't use an
sql statement is because I need to join data from a local table
and a remote table. the remote table is not a linked table, for
each row in the list box I regenerate the connection string.

I really don't see the issue. You can specify a connect string in
the FROM clause of the SQL.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/