FIND RECORD ADO RECORDSET

[99Chuck99]

NEED SOME HELP. I HAVE A DATA ACCESS PAGE THAT I'M TRING TO FIND A RECORD AFTER REQUERY PAGE. I HAVE PUT SOME MSGBOX TO SEE IF THE PARAMETERS ARE THERE. MUST HAVE A SYNTEX PROBLEM IN MY FIND STATEMENT. ANY HELP WOULD BE APPREICIATED.


MSODSC.CurrentSection.DataPage.Requery
msgbox MSODSC.DataPages(0).Recordset.RecordCount
msgbox MSODSC.DataPages(0).Recordset.Fields.Count
msgbox MSODSC.DataPages(0).Recordset.Fields("DOCUMENT NUMBER").Value
msgbox MSODSC.DataPages(0).Recordset.Fields("DOCUMENT NUMBER").Name
MSODSC.DataPages(0).Recordset.Find([DOCUMENT NUMBER] = H6085)

 

[PWise]

try

MSODSC.DataPages(0).Recordset.Find("[DOCUMENT NUMBER] = H6085")