Adding a field from another form after it was created

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KLP - 23 Mar 2005 16:51 GMT

I have 3 table that are linked in this order:

Loan info (main),
Collateral - linked to Loan Info (1 to many, loan info is the 1 and this is
the many)
Real Estate FS - linked to Collateral (1 to many, Collateral is the 1 and
this is the many)

In the Real Estate FS form, I need to pull in the loan payment from the Loan
Info table for a computation in the Real Estate FS form. In design view, I
try to add the field, I get a ?name error. The loan info field were not
included in the field selected when the form was created.

How do I add a field from another table without redoing the form entirely.

Reply to this Message

John Vinson - 01 Apr 2005 00:22 GMT

>I have 3 table that are linked in this order:
>
[quoted text clipped - 10 lines]
>
>How do I add a field from another table without redoing the form entirely.

Are these three separate *forms*? or two Subforms on a main form?

To display (but not edit) data from another table, you can set the
Control Source of a textbox to

=DLookUp("[fieldname]", "[Loan Info]", "[LoanNumber] = '" &
[LoanNumber] & "'")

assuming fieldnames and that the LoanNumber is a text field.

John W. Vinson[MVP]

Reply to this Message

KLP - 01 Apr 2005 02:19 GMT

Loan info is the main form, and collateral is the sub form, and real estate
FS is a sub form to Collateral.

I will try your suggestion.

Kelvin

> >I have 3 table that are linked in this order:
> >
[quoted text clipped - 22 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 01 Apr 2005 03:55 GMT

>Loan info is the main form, and collateral is the sub form, and real estate
>FS is a sub form to Collateral.

If there's a textbox named txtPayment (which need not be visible) on
the mainform bound to the Payment field, you can use either

=Formname!txtPayment

or

=Parent!Parent!txtPayment

John W. Vinson[MVP]

Reply to this Message