Field population based on previous combo box selection.

[NovDragon]

I have a combo box on my form populated with records from a table. I would
like another field on the form to populate with data from the same table but
a different column. I am new to access and having trouble with this problem.
Thank you for any help you can provide.

 

[NovDragon]

* I would like the second field to populate based on the combo box selection.

 

[Ofer Cohen]

Check this link on "Use the Column Property of a Combo Box"

http://www.mvps.org/access/forms/frm0058.htm