Fill ComboBox At Runtime

[rishi_375]

Hi,
I want to fill combo box at runtime. I create a Recordset and i want to bind this recordset value to combobx.

 

[WayneRyan]

rishi,

You don't need a recordset, that makes it more difficult.

At run-time, you can assign a query or a table as the combo's
RowSource. First, Me.Combo.RowSource = "SomeQuery".
Then just Me.Combo.Requery and it's all set to go.

Course if it's always the same query, you're OK anyway.

Wayne