I apologise if this is simple, but it has been bugging me for weeks. I have a template form which is populated by inserting an SQL string into its RecordSource property. The users have asked if I can display the number of records that are displayed on the form in a Text box in the form footer. For some reason they do not want the Navigation boxes to be displayed which is by far the simplest solution. On the occasions when the source is a table it is simple using Dcount, but when the source is a query string I have tried all I can think of to populate the TextBox using the form's OnOpen event (Me.Text1.value = Me.RecordSource.Recordcount etc) but cannot find a way to do it. Does anyone know a way to do this?

Thanks

Spikey

Have you tried using a combination DCOUNT with Me.RecordSource? That is

Me.Text1 = DCount("[Pick a field]", Me.RecordSource)


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Wonderful! It was probably the only combination of DCount and me.RecordSource I hadn't tried.

Many, many thnks.

PMJIH.

There's one thing you should know about the field Greg specified as "[Pick a field]". If you pick a field that could be Null, the record won't be counted. Recommend using either "*" or the ID field (a field which should never be null) of the record source.