Adding Combo Data to Fields

[pepegot]

I have a Combo Box that places the Address into the given Address field. How can I have it place the second and third cloumns, from the Combo Box into the next two adjacent fields on the Form (Last Name & First Name)?
Please describe in detail, not just code, but where a how it goes. I am new at this thing.

 

[ColinEssex]

In the AfterUpdate property of the ComboBox.

 Me.TxtBoxName = Me.ComboBoxName.Column(2)

Remember ComboBox columns are numbered 0,1,2,3 etc
Col