copy text From Combo to text or list box on a form? How?

[AliAmanAmarAdel]

I have a table(APPLICATION_CUSTOMER) with following fields.
APPlCust(PK)
CustomerID(FK)
APpplication_ID(FK)
Customer_Name(Lable for storing chosen customer Name)
Application_Description(Lable for storing chosen APP Name)

I have a form to fill this fields.The form has all this fields + two combo boxes linked to Customer.Customer_Name & APPLICATION.App_Desc

Once User chooses a Customer Name And App Desc I want to fill them in the two label feilds.(List boxes)

my sql is: in a command box"ADD RECORD"

lstCustName.RowSource = "SELECT Customer.CustomerName FROM Customer WHERE Customer.CustomerID = cmbCustName.value ;"
The problem is once I click "ADD RECORD" for one record all my other records in the form will get filled with that entry. [sig][/sig]