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.
|
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. |