View Full Version : Recordsource


Ankarn
07-08-2008, 12:50 AM
How can i make two tables my recordsource? what do i write in the recordsource-property? The tables are linked.

namliam
07-08-2008, 12:58 AM
Just make a query and use that as your recordset :confused:

Ankarn
07-08-2008, 01:13 AM
but isn't there an easier way? cant i just write two tables into the recordsource?

namliam
07-08-2008, 01:51 AM
No... You have to tell access what to use as a recordsource. If you have 2 tables as a recordsource you have to tell access that. The only way to do that is via a query.

You can make a seperate query, visible in the Database screen. Or make a query in your recordsource. But a query needs to be made

namliam
07-08-2008, 01:53 AM
Just thought of something... You can also make a subform, in essance making the query using 2 seperate forms... Still a query, but 2 forms instead of just 1.

Which ever way you prefer...

Ankarn
07-08-2008, 02:28 AM
hehe. ok ok

i'll make a query.