Using After update and getting error

[koncreat]

In the form invoices I am using a field, bill_to_name that is supposed to update the three fields directly beneath it. I have this setup in the after update property of the bill_to_name comb box. When I try to select a record in the box i am getting a VB error. I have attached a copy of the database.

[davegri]

Should be like this:

Option Compare Database
Option Explicit


Private Sub bill_to_name_AfterUpdate()
bill_to_street = bill_to_name.Column(1)
bill_to_city = bill_to_name.Column(2)
bill_to_state = bill_to_name.Column(3)
End Sub

[koncreat]

Thank you that did it!