look up table

[dr223]

Hi,

I have a table on my db called nationality which is built up of two fields;
1) nation_code 2) nation

on My main form, called stud_details I have a field called cbonation which has a combo box. What I want to do is when I scroll on the combo box and find a nation such as UK with the code instead of it being saved on the table instead the nation_code should be saved.

This code is not working any help please

Private Sub cbonation_AfterUpdate()
cbonation = Me.Nationality.Column(0)
End Sub


Thanks

 

[Uncle Gizmo]

This is a double post, I have already supplied at least one answer in another thread. Please go to that thread if you have a suitable answer. Cheers Tony.