Two subform datasheets on same form - problem

  • Thread starter Thread starter WHardy7
  • Start date Start date
W

WHardy7

I have two tables - Subjects (History, Chemistry, Psychology, etc.) and
Books (Title1, Title2, etc.) Subjects if the Parent and Books is the
Child, linked by SubjectID.

I need a form that shows all Subjects on the left side, preferably in a
datasheet. On the right side I need to see all Books related to that
Subject. The challenge is that I need to see all Subjects and be able
to arrow key through them with the related records reflected in Books.

My problem is that a form bound to Subjects wants to limit Subjects to
one record (the current one.) Therefore, I can only one Subject at a
time.

I know that I can separate these into separate forms or use pop-ups,
but ease-of-use and intuitive design makes the single form more
desirable.

Any ideas?

Thank you,
Wayne
 
WHardy7 said:
I have two tables - Subjects (History, Chemistry, Psychology, etc.) and
Books (Title1, Title2, etc.) Subjects if the Parent and Books is the
Child, linked by SubjectID.

I need a form that shows all Subjects on the left side, preferably in a
datasheet. On the right side I need to see all Books related to that
Subject. The challenge is that I need to see all Subjects and be able
to arrow key through them with the related records reflected in Books.

My problem is that a form bound to Subjects wants to limit Subjects to
one record (the current one.) Therefore, I can only one Subject at a
time.

I know that I can separate these into separate forms or use pop-ups,
but ease-of-use and intuitive design makes the single form more
desirable.
Click to expand...

If you can live with over/under instead of side-by-side, you can make the
Subjects form a continuous form (not Datasheet) and then place the Books subform
in its footer. If you really want side-by-side, then embed both forms as
subforms inside an unbound Parent form. You can then place a hidden control on
the Parent form that reads the value of the current Subjects form selected and
use that as the MasterLink property for the Books subform.
 
Back
Top