ComboBox problem

[Vladimir]

Hello,

I have a form (let's call it MainForm) which has one combobox (Combo) and
one subform (SubForm). MainForm is bounded to the table (MainTable) which
has one field ID and some other fields. There is also another table
(SubTable) with following fields: MainID, Year and some other fields. I want
to populate Combo with Year items from SubTable where MainID = ID. SubForm
displays other info from SubTable where Year is equal to the value of Combo
and MainID = ID.

Combo has the follwong properties:
Row Source Type = Table/Query
Row Source = select [Year] from SubTable where [MainID] = [ID]

Questions:
1) I need that if Combo isn't empty it has its first item displayed in its
textbox. Initially textbox is always empty (even if drop down list is not).
2) When I travel through records in MainForm, Combo doesn't change its
content. It contains items that refer to the first record.
3) How can I bound SubForm to Combo?

Regards,
Vladimir.