Linking two forms

[GillianX]

Hi there,

I have two forms linked as tables by a one-to-many relationship.

This is what I need. A control on the "one" form which opens the "many" form
but which filters records within the "many" form using the primary key in the
"one" form.

How do I do this? Many thanks.

 

[John W. Vinson]

Hi there,

I have two forms linked as tables by a one-to-many relationship.

This is what I need. A control on the "one" form which opens the "many" form
but which filters records within the "many" form using the primary key in the
"one" form.

How do I do this? Many thanks.

By far the simplest way to do this is to make the "many" form a Subform on the
"one" form, using the primary key of the "one" table as the Master Link Field
and the corresponding foreign key as the Child Link Field. If you need space
on the screen, you can use a Tab Control with mainform controls on one page,
and the Subform on the second page.

Do you really want to have a second independent form pop up? It can be done,
but it takes a fair bit of work.

John W. Vinson [MVP]