Problem with 2 subforms on Main form

[Guest]

I am stuck with a problem that no one seems able to solve.
I need a form with two subform-datasheets on it.
The one on the left side contains Subjects (history, geography, etc.)
The one on the right side contains Books (Title1, Title2, etc.)
They are linked by SubjectID.
So, I need to be able to see ALL Subjects on the left side while the right
side reflects the related Books.
The main form, though, seems determined to only view one Subject at a time.
I cannot find a way to show all Subjects at the same time, instead of one at
a time without using a pop-up.

Can this be done on one form? It seems so elementary for Access. I know I
must be missing something simple!

Wayne

 

[Guest]

Try changing the Subform on the left side with a list
box. When you select a Subject on the left, you can use
code to change the list of books on the right.