Count of form records
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?