Update Text Fields when List Clicked

[MrAustin]

Hello everyone:

I have the following situation... I have created a listbox that lists customers and their account number inside. What I want is that when I click each customer, the text fields below (each having the name of their respective attribute: name, adds, zip, state, etc) to fill with the appropriate information.

Can someone give me some hints on how to accomplish this?

Thanks!

 

[Jon K]

I have attached a sample database with a table taken from the NorthWind sample. The database contains two forms: one bound, one unbound.

The bound form was created using the form wizard, and the list box was added using the Control Wizards on the toolbox.

The unbound form was created manually.

The code used is in the After Update Event of the list boxes.
.

 

[MrAustin]

Thanks a bunch, that helped tremedously