Is it possible to use a dataset as the bind for the datanavigator? I have: (This is for a microsoft access query)
Dim
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"
daFindings =
daFindings.Fill(dsFindings,
But that did nothing....
Thanks!