As OP wrote the loop, you are correct, tg. However, it all depends on what he wants in the grid, and where he wants it put.
This following example puts name_f (from employment table) into the first column of my MSFlexGrid, starting with row # 1 (I placed a header row on my grid):
Code:
cmd.CommandText = "select employment.name_f, employment.firstname from employment INNER JOIN owner "
cmd.CommandText = cmd.CommandText + "ON employment.name_f=owner.name_f where owner.id = " & Text1.Text
Set rs = cmd.Execute
Grid1.Col = 0
Grid1.Row = 0
Do While Not rs.EOF
Grid1.Row = Grid1.Row + 1
Grid1.Text = rs!name_f
rs.MoveNext
Loop
If OP wants other fields in more columns, simple to modify the loop.
SO many ways of doing this stuff---mine is just one. As he was planning a for-loop in the OP, I just stayed in that vein, that's all. And I am not sure if he is using datagrids or flexgrids.....and that makes even more ways of displaying DB data.....
The last posting by CM definitely has an incorrect loop, as I told him how to change that earlier on, but he kept his original (even misspelling his grid name).