Recordsource

[Ankarn]

How can i make two tables my recordsource? what do i write in the recordsource-property? The tables are linked.

 

[namliam]

Just make a query and use that as your recordset

 

[Ankarn]

but isn't there an easier way? cant i just write two tables into the recordsource?

 

[namliam]

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]

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]

hehe. ok ok

i'll make a query.