Combo Box and Form Problem

[osimini1]

I have Combo box in a form as a search criteria to pull customer information from the Customer information and populate the form. The combo box will populate with the customer name, but will not populate form with customer information, rather what will appear in the form is the first record in the table and will not change even if you choose another customer. For example I have a table tblCustomer with customer information:
CustomerID, FirstName, LastName, Address, LicenseNo, Phone. These are records in the form that are suposed to be fill once the customer name is selected from the combo box.when I chose a particular customer name.

I used SELECT tblCustomer ........ to populate the combo box.

Is there something I am doing wrong here.

 

[Remou]

Did you use the wizard to create this combo? The wizard will guide you through creating a combo to find a record on your form. You will then need a little code to either clear the combo, or to match it with a record, if the user is allowed to navigates through the records.