-
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 :)