Hi,
Can anyone please tell me how to populate a DBgrid using a recordset. I have created my recordset set using the following code:

Set rs = New adodb.Recordset
rs.Open lpzSQL, conn, adOpenKeyset, adLockOptimistic

and I know that it succeeds in getting the info from the DB.
Any suggestions would be greatly appreciated.
Cheers!