using the flexigrid control

[Johnny23]

my code all works but i dont know how to display my query result in my flexigrid control

Private Sub Command1_Click()

Dim dyna As Recordset
Dim theError As Long
Dim theid As Long


 theid = txtCandidateID
 SQL = "Select * from candidate  where candidateID = " & theid & "'"
On Local Error Resume Next

Set dyna = db.OpenRecordset(SQL, dbOpenDynaset, dbSQLPassThrough + dbSeeChanges)
theError = Err
On Local Error GoTo 0
'what do i do next to get my query result into my 'flexigrid 'control???

[/code]