Hi
Code:
Private Sub DBCombo1_Change()

Data2.RecordSource = "select * from CustomerPriceList where productcodeno='" & Trim(DBCombo1.Text) & "'"

Data2.Refresh
The above codes work perfectly but the problem is when the user select a item inside the combobox the list of productcodeno inside the combobox will be gone

My question is how can i maintain the list of productcodeno inside the combobox when the SQL statement is executed?

I would be gratefull if anyone out here can help out
Thanks in advance!!