counting number of records returned

[questionit]

HI

Is there a way to count number of Records on a continous form.
Or
Is there a way of finding number of records returned when we set recordsource of a form like this:

Me.Form.RecordSource  = 'SQL Query'
 

Thanks
Qi

[Rabbit]

Me.Recordset.RecordCount
Me.SubformName.Form.Recordset.RecordCount

[questionit]

Thanks Rabbit ......

Me.Recordset.RecordCount
Me.SubformName.Form.Recordset.RecordCount

[MGrowneyARSI]

You can also use the code below by just replacing the dlookup with dcout it has alot of flexabilty with the critiria in what record you count cheers

'A Function with No Criteria

1.) =DLookUp("[LastName]", "Employees")
-----------------------------------------------------------------------------------------------------
'Specifying Numeric Criteria

1.) =DLookUp("[LastName]", "Employees", "[EmployeeID] = 7")
-----------------------------------------------------------------------------------------------------
'Specifying Numeric Criteria That Comes from a Field on a Form

1.) =DLookUp("[LastName]", "Employees",
"[EmployeeID] = " & Forms![Orders]![EmployeeID])

2.) =DLookUp("[LastName]", "Employees",
"[EmployeeID] = Forms![Orders]![EmployeeID]")
----------------------------------------------------------------------------------------------------
'Specifying Textual Criteria

1.) =DLookUp("[Title]", "Employees", "[LastName] = 'Callahan'")

2.) =DLookUp("[Title]", "Employees", "[LastName] = ""Callahan""")
-----------------------------------------------------------------------------------------------------
'Specifying Textual Criteria That Comes from a Field on a Form

1.) =DLookup("[ContactName]", "[Customers]",
"[CustomerID]='" & Forms![Orders]![CustomerID] & "'")
-----------------------------------------------------------------------------------------------------
'Specifying Date Criteria

1.) =DLookUp("[LastName]", "Employees", "[BirthDate] = #01-27-66#")
-----------------------------------------------------------------------------------------------------
'Specifying Multiple Fields in the Criteria

1.) =DLookUp("[OrderID]", "Orders",
"[CustomerID] = 'SIMOB' And [EmployeeID] = 2")

2.) Result = DLookup("[OrderID]", "Orders",
"[CustomerID] = '" & CustID & "' And [EmployeeID] = " & EmpID)
-----------------------------------------------------------------------------------------------------