From: A Bit Frustrated A Bit on
I have two tables with 1:1 relationship. Both have same key field (SS Number).
There are two forms, one for each table.

When I open Form A there is a button to open Form B. When Form B opens, I
want SS Number field to equal the SS Number on the current record in Form A.

How do I do this?

Thank you in advance.
From: Dennis on
Well, IMO the easiest way would be to make Form B a subform of A, and linking
via the common key. Or you could make Form A a tabbed form, and A would be
the first tab and B would be the second.

Just a couple of random thoughts...




"A Bit Frustrated" wrote:

> I have two tables with 1:1 relationship. Both have same key field (SS Number).
> There are two forms, one for each table.
>
> When I open Form A there is a button to open Form B. When Form B opens, I
> want SS Number field to equal the SS Number on the current record in Form A.
>
> How do I do this?
>
> Thank you in advance.
From: John W. Vinson on
On Thu, 25 Mar 2010 12:36:01 -0700, A Bit Frustrated <A Bit
Frustrated(a)discussions.microsoft.com> wrote:

>I have two tables with 1:1 relationship. Both have same key field (SS Number).
>There are two forms, one for each table.

Why? One to one relationships are *very rare*; are you intentionally using
Subclassing, or Table-based Record Security, or one of the other uncommon uses
for the technique? Could you not just include the second table's fields in the
first?

>When I open Form A there is a button to open Form B. When Form B opens, I
>want SS Number field to equal the SS Number on the current record in Form A.
>
>How do I do this?

By far the simplest way is to make form B a Subform of form A, and use the SS
Number as the Master/Child Link Field. You can also use VBA code in the
OpenForm Method to a) set the WhereCondition to limit the second form to the
corresponding record and b) use the OpenArgs property to pass the SS Number,
and then use the second form's Open event to retrieve that value and use it as
the default value of the second form.

--

John W. Vinson [MVP]