Compile Error in VB Select Query 1

[BV874]

Hello Everyone,
I am receiving a compile error on the following code for method or data member not found. Any help would be greatly appreciated. Thanks!


Dim Mysql As String
Dim RS As Recordset
Mysql = "Select [CountOfCUS_NUM] from [tblUploadDuplicates]"
RS.Open Mysql, CurrentProject.Connection
RS.MoveFirst

If RS.Fields([CountOfCUS_NUM]) > 0 Then
MsgBox "The file you are attempting to upload has already been processed", vbCritical + vbOKOnly, "ERROR!"
Cancel = True
Exit Sub
End If

 

[PHV]

If RS.Fields([!]"[/!][CountOfCUS_NUM][!]"[/!]) > 0 Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[BV874]

Thanks PHV!