limit data to subform list (1 Viewer)

DalGal

Registered User.
Local time
Today, 05:10
Joined
Oct 23, 2018
Messages
23
I have a main form with:
Center, Month, Amount, Loan ID

Subform:
Loan ID, Lender, Center, etc.

The subform loads the applicable list of loans based on the Center entered on the main form.
I'm trying to limit the Loan ID on the main form to the Loan ID list showing in the subform.

Each center has several loans. Each loan has monthly payment amounts.
I have tables for: Center list, Loan list, and Monthly payments
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:10
Joined
May 7, 2009
Messages
19,175
its the other way ariund. the main form should limit the list of the sub form.
use master/child link fields property of the subform.
use both loan id for th link fields.
 

DalGal

Registered User.
Local time
Today, 05:10
Joined
Oct 23, 2018
Messages
23
The main form is a data entry form. The subform populates the loans for that center once the center name is entered, so it is limited. The problem is the ID on the main form will take any loan number, and is not limiting the user to the loans listed on the subform list for that center.
So in this case, if I link the fields, will that limit it?
 

Users who are viewing this thread

Top Bottom