Enter data (1 Viewer)

[endri81]

Hi All
I have a table Cities with name of cities and IDs.For example:
ID City
1 LA
2 Moscow
3 Paris
4 London
I wrote code like this
If (Me!Text430.Value = "LA") Then
Me!Text431.Value = 1 to enter city code and to get the ID.
I want in textbox432 to enter ID and to get LA
Also I want textbox430 and 432 to save the data at the same place so the user can chose by himself to enter number or city code(LA) if he doesnt remember info and this to be saved same table.
Please help

 

[John Big Booty]

Perhaps the sample posted here will give you some ideas.