Combobox to Store Value for Nationality

[TheArgyll]

Good Afternoon All,
I am now attempting to get the user to enter each member of staffs nationality.
I currently have a drop down Combobox that I populate with "Nationality" from t_Nationality using the following query.

SELECT DISTINCT Nationality FROM t_Nationality;

In the Row Source property. I would then like to write the selected value to the t_Person.Nationality field for the current record.
Can anyone please assist me with this?

Thanks,
Rob

 

[alansidman]

Mike Alexander has several videos on combo boxes at this location

DataPig Technologies Access Videos