Updating Combo Box values in tables

[sarah seah]

I created combo boxes using form. However, when I look at the table, it is updated with values rather than the entries I have entered.

Eg :
Country table :
ID Country
1 SIN
2 Malaysia

Main Dbase
Country Name Address
1 Sarah Seah Yishun
1 Nur Woodlands.

It does not populate the Country in the Country field, instead it populates the ID only.

How can I make it populate the Country instead of the ID?

[sashi]

Hi Sarah,

there could be alot of reason why this is happening.. have you created the table relationship.. it could be your SQL statement too..

pls post your current code segment.. it's much easier to validate in that way.. well.. pls remove any crucial information from your code segment before posting it.. take care my fren..