Is it possible to use a dataset as the bind for the datanavigator? I have: (This is for a microsoft access query)

Dim dsFindings As New DataSet
Dim daFindings As OleDb.OleDbDataAdapter

sql = "select tbl_findings.id, tbl_findings.location, tbl_findings.RAC, tbl_findings.checklist_number, tbl_findings.checklist, tbl_findings.corrective_actions,tbl_findings.reference,tbl_findings.notes, tbl_findings.discrepnum from tbl_findings where opfac='" & curOpfac & "' and visitdate=#" & curVisitDate & "# and visittype='" & curVisitType & "' order by tbl_findings.discrepnum"

' run the sql statement against the connection string

daFindings = New OleDb.OleDbDataAdapter(sql, con)

' fill the dataset with data

daFindings.Fill(dsFindings, "tbl_Findings")

If this is possible, how would I bind it? I tried:
NDataNavigator1.DataNavigatorElement.DataSource = dsFindings

But that did nothing....

Thanks!

Thanks Angel, that works perfectly. Now that I have the navigator running, and displaying the correct number of records etc...

How do I assign a function/sub to the next, next page, last record buttons so I can advance the records? I already have the functions next,prev etc designed and working, just need to know how I access the controls button pressed and assign it to the right function...

Thanks