AutolookUp and Add Data in Form

[Johnrg]

I have a form for entering customer data that saves in a table called Customers

There are three feilds in this form called Country, CountryPrefixCode and Region. I want to select the country using a combobox and have the responding countryprefixcode and region info autoentered.

The first field called "Country" is a combo box that look up values in column 2 of a table called CurrencyTypes. Once a country is selected I want the related data from Column three to enter into the CountryCode Feild and Column four to enter into Region feild.

I have got this working by using the following as the control source in each feild
=[country].[column](3) and
=[country].[column](4)

This works fine however the autolooked up data from these two columns shows in the form but is not entered and saved in the customers table.

What am I missing here? Why is it not being entered into the customers table when I save and close?

JohnG

 

[pbaldy]

This kind of thing, including the caution against it:

http://allenbrowne.com/casu-14.html