This is gold:
"Richard Rost on 2/28/2008: If you just read the value of the combo box, you're getting column zero which is PROBABLY your ID field. If you need to get the name out of the second column, access it like this =ComboBoxName.Column(1) Remember the first column is column(0). We cover this in Access 302."

Exactly what I wanted to know too ! Now when I enter a Town, the Area box is automatically recorded from my TownAreaT.

Thank you Thank you Thank you

---

Reply from Richard Rost:

Glad I could help. :)