Is there a way to display two linked datasheets on a single form?

Best Microsoft Access Programmer Portland OR

I can link a form and a sub form and where one is a data sheet and the other is a form. I made a third form and put each data sheet into it, but I cant figure out how to link them so that when you select a record in the top data sheet it automatically selects the corresponding record on the bottom data sheet.

All of this is built on a query that takes data from two tables.

submitted by /u/MotherGarbage
[link] [comments]

Microsoft Acess Developer Portland OR