How to populate Janus Grid

[vbpadawan]

I am evaluating the Janus grid before I purchase it. I have never used it and don't even know how to populate it. I have two columns; the first is just a text field and the second I want to be a dropdown list. I have set the second column to be a dropdown in the properties box. I don't even know how to begin populating either column with my data from my recordset. The only way I have been able to get a value to display in the first column is by:
GridEX1.Columns(1).DefaultValue myRS!ID

I can't begin to get the dropdown to populate. Here is what I have tried:
Do Until myRS.EOF
GridEX1.Columns(1).ValueList.Add 0, myRS!Name

myRS.MoveNext
Loop

This gives me an error.

Can someone please help me get started on this control.

Thanks.

 

[vbpadawan]

Correction:

GridEX1.Columns(2).ValueList.Add 0, myRS!Name
NOT
GridEX1.Columns(1).ValueList.Add 0, myRS!Name