Combo Box Autofilling with Data from another table

[Huddle]

I created the below formula using the form's table as the base on the combo box. I didn't want to have to scroll through all the table records to get the data even though the autofill would work the way it should.

I created a lookup table with the same info and have the combo box directed to it. Everything is the same except the combo box is pointed to the look up table. Is there a different syntax I should be using?

Private Sub Combo29_AfterUpdate()
Me.LastName = Me.Combo29(2)
Me.Title = Me.Combo29(3)
Me.Add1 = Me.Combo29(4)
Me.Add2 = Me.Combo29(5)
Me.City = Me.Combo29(6)
Me.State = Me.Combo29(7)
Me.Zip = Me.Combo29(8)
Me.WkPh = Me.Combo29(9)
Me.Extension = Me.Combo29(10)
Me.CellPh = Me.Combo29(11)
Me.Fax = Me.Combo29(12)
Me.Email = Me.Combo29(13)

[Rawb]

Try using Me.Combo.Column(x) instead and see if that works.

[Huddle]

You are so right...you know it's time to eat when you make such a dumb mistake. Thanks for your help.