RECORDCOUNT WHEN USING Me.RecordSource = sqlline

[fsweb2002]

Hi
I have a continuous form which displays records matching a query.
The query is created and run using

Me.RecordSource = sqlline ' sqlline being the SQL query

I now need to use the recordcount property to find out how many records have been selected by the query.

I don´t know how to do this !

Your help is appreciated

 

[jebry]

Hi!

Open it as a recordset, like this:

Dim rst As DAO.Recordset

Set rst = CurrentDb.OpenRecordset(sqlline, dbOpendynaset)

If rst.EOF = True and rst.BOF = True Then
Call MsgBox("No Records&quot
Else
rst.MoveLast
rst.MoveFirst
rst.RecordCount is the number of records and you can store it anywhere you want
End If

Set rst = Nothing

hth
Jeff Bridgham
bridgham@purdue.edu

 

[fsweb2002]

thanks!