Forms not reflecting changes made on VB Editor

[fun4all]

Hello,

I am very new to Microsoft Access and need some help using VB editor to customize forms. I entered code for an event that creates an auto fill-in form that completes the form according to what is selected in a combo box. But when I go to select a record in the combo box, none of the other fields on the form update. Also, the empty fields still act as if no changes were made to the event (goes down a list of records as I press Tab).

My event looks like this:

Option Compare Database
Option Explicit


Private Sub LastName_AfterUpdate()

Me.FirstName = DLookup("FirstName", "Table1", "ID=" & ID)

Me.Address = DLookup("Address", "Table1", "ID=" & ID)
Me.City = DLookup("City", "Table1", "ID=" & ID)

End Sub


Which is suppose to fill out text boxes named FirstName, Address, and City depending on the LastName selected in a combo box.




Thanks in advance for the help!

[RuralGuy]

Where is your system to get the ID you need to do the Lookup's?

[fun4all]

I'm sorry I don't really understand what I need regarding the ID lookup. I thought I could refer to the ID as any other field on the datasheet? Could you please elaborate a bit?

[RuralGuy]

In order for us to communicate successfully we need to be real specific in what we call objects.
Is your form in Datasheet View?
Do you have another control on your form named ID? If you do then what fills it in?
Is LastName the name of your ComboBox?
What is the RecordSource of the ComboBox?

[fun4all]

My form is currently not in datasheet view. I could make it so if needed. There is a text box control on my form named ID. The ID field fill sin the ID text box. LastName is the name of the ComboBox and its row source is the field named LastName.

Thank You.

[RuralGuy]

The RowSource of the LastName ComboBox is probably not the LastName field. My guess is that is the ControlSource of the ComboBox. Are you using the ComboBox to look up existing records in the RecordSource of the Form?