me.recordsource issue

[ashina.w2]

Hi.

I have built a tabular form and trying to populate the data from a
table which is not in its .mbd file. So i have set the rst object to
that mdb file from where i want to fetch the data but when i am
saying

me.recordsource = rst

it is not correct. And if i say me.recordsource=rst.source then i get
error the table not found and it is because the code is searching the
table within its mdb file.

Please help.

Thanks in advance.
Regards,

 

[steve]

Why don't you just create a linked table to the external data in your
current database?

Steve

 

[ashina.w2]

Hi,

Dont want to go for linked table as the database destination keeps on
changing. Do let me know if there is any althernative

Regards,

 

[Guest]

If your external database is also Access, you can create a query:

Select * From someTable in 'C:\Temp\YourExternalDatabase.mdb'

Save this query, then use that as the recordsource for your form. Will
undoubtedly be slower this way than linking the table, but this has the same
problem that you have to know where the database resides.

HTH
Dale