Dbcombo Help Needed

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!!

use another data control (other than data2) to populate the combobox

an example at:
http://pages.about.com/vbmakai/dao2.htm

Thanks a lot makai !!!
I tried your suggestion and it works perfectly :)