set default value for unbound cbo from different table than source

[laskowv]

I have an unbound cbo that displays the term ending dates; which is bound to
a subform to list data in a file linked to these term dates; let's call this
table "Terms" with TermID as key and "TermDate" as the field. I also have a
"company" table that is set by admin with the company's current term date
(TermID is the field). This is on the Screen maintenance form for the
Divisions.

What I need is for the cbo to default first to the "current term" or TermID
from this "company" table; even though is still needs to perform the looks
from the "Terms" table; for every Division while scrolling through each
Division record.

For example: TermID = 91 is the id for term ending date 2011. As the
records are scrolled through on the screen, the subform uses the "TermID" in
the combo box to displays the records (master-child links are the DivisionID
and TermID). If the user selects a different term from the Division form -
it displays the data on the subform for that Division and term end date.

Hence, I want all the Division's subform records to start from the "term
date" or TermID in the company table. (this is similar to accounting
periods). Term dates are currently in the file dating back to 1921; and I
don't them to be confused and not notice the date is not the current term.

Thanks...