Why .RecordCount always return the number of all records?

[reneford]

Why ".RecordCount" always return the number of all records of the entire table? I just want to have the number of records return by the request. (The request can be a select, delete, ...)

With Form1.Adodc1
      .ConnectionString = "....mdb...Access..."
      .RecordSource = "" & Request & ""
      NUMOFRECORDS = .Recordset.RecordCount
      .Refresh
    End With

 

[johnwm]

Try doing a Refresh before reading your Recordcount rather than after

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[DevonTaig]

This code worked for me.

Adodc2.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Program Files\Miner and Miner\ArcFM Solution\Sample Data\Geodatabases\ArcGIS9_Minerville.mdb;Persist Security Info=False"
Adodc2.CommandType = adCmdText
Adodc2.RecordSource = "SELECT * FROM TRANSFORMER WHERE OBJECTID < 100"
Adodc2.Refresh
Dim rs As ADODB.Recordset
Set rs = Adodc2.Recordset
MsgBox "Number of records " + CStr(rs.RecordCount)