Return row 1 of recordset

Dear friends,

I am familiar with returning a recordset referencing the column name or column index.

Me.ListBox1.AddItem rst(0) - ref column index

however, i would like to return the first row of the recordset.

how should i reference this?

thank you :)

To return the values of columns in a specific Row you must Move to that Row.

The Recordset object has several Move methods, the one you need to use is MoveFirst.

rst.MoveFirst
Me.ListBox1.AddItem rst(0) - ref column index