Combo box to limit selection based on current record in form

  • Thread starter Thread starter laskowv
  • Start date Start date
L

laskowv

I want my combo box to only display the valid ranges from a table that match
the PK in my current form. Here are my tables:

Division
DivisionID PK
DivTerms

Terms
TermID PK
TermEndDate

Division Terms
ID PK
DivisionID FK
TermID FK

The goal is to have the combo box to to list the valid term end dates for
the specific division record that I am on in the form. For example, if I'm
on Division 1 (California); then I want the combo box to display the terms
from table Division Terms (which is linked to the Terms table to display the
TermEndDate); and then bind the TermID from Division Terms table into
DivTerms field in the Division table.

Where I'm having trouble is trying to only display records from the Division
Terms table where DivisionID = DivisionID on my form.

Thanks..Valerie
 
Back
Top