[RESOLVED] Bind data to ComboBox in Access form at Run Time ???

[nileshhthakur2004]

hi all,

i have one from on which i have number of control i have one Combobox CustomerName on my form when user select "customername" the data related to that customer is display in all control now i have one more combobox on same form i want to bind the data to this 2 nd combobox how can i do this ??

How can i write the binddata property of combobox through code at runtime ??

suppose code is like this ....


is this posible ???

select pricecode from price where customerid = "& combobox1.value &"
if rs.BOF = false And rs.EOF = false then
while rs.EOF
combobox2.additem(rs("pricecode "))
wend
Endif

the code which i write is just an example, is this posible ?? How ??
additem method is not present there ....

pls help me regarding this ...