Help with Combo box

[Joe Cilinceon]

I have a combo box on a form that lists the StateAbbr., StateName, and
CountryName. For example KY, Kentucky, USA. Now my question is how would I
access the CountryName (3rd field in the combo box) when I pick the state.
I want to use this to preload the Country field on the form. I have tried
putting the following line in the AfterUpdate event on the State field:
Me.MailCountry = Me.cboStateCountry.CountryName (This gets a error).

 

[Ken Snell [MVP]]

See The ACCESS Web for one way to do this:
http://www.mvps.org/access/forms/frm0058.htm

 

[Joe Cilinceon]

Thanks Ken that will work great.