Can the recordsource of a form be in another database ? If so , how ?

[DaJoin]

I made a little application, and for testing everthing (forms, tables) was located in the same mdb file. Now I have to separate the forms from the data, and I cannot realy find how to do this.

The recordsource of the form was set at runtime (depending on a few criteria) , I hope I'll still be able to do this with tables located in a different database .

Thanks in advance for the golden tips you'll provide me .

 

[gol4]

the simplest solution would be to just create a link to the tables that contain your recordsource

file-get external data -link tables