Error 438

[psquillace]

Hello:
I am trying to replicate the Northwind example where you pick a
customer from the drop down and it fills in all the info, however I keep
getting an error if I add more than one line of code.

I have my code in the event handler after update on the combo box to be :

Private Sub CustomerName_AfterUpdate()
If Not IsNull(Me!CustomerName) Then
Me!AddressTextBox = Me!CustomerName.Column(1)
Me!Address2 = Me!CustomerName.Column(2)
End If
End Sub

But when I run the form I get error 438 which says it cannot process this
object or method.

If I take out that 2nd line then it works fine but I need to fill in more
than just addressTextBox, I have address 2 and city bla bla bla.

Any help would be appreciated.

Paul

 

[Douglas J Steele]

How many columns have you indicated are in the combo box (the Column Count
property)?

 

[psquillace]

Thanks for the quick response on this,

I found that the LABEL is differently named than the TEXT BOX itself.

How embarrassing, and the name was not matching. That is why I was getting
that error.

Thanks so much for your help,

Paul