Topvalues from a Form

[Chris RR]

I have a form that displays the results of a Topvalues query. My user would like to be able to choose the number of records displayed.

Is there a simple way to do this? I am running against an Access table here, no ODBC. The query and the form are pretty much plain-vanilla.

If worst comes to worst, I think that maybe I could rewrite the query in code, using the value that the user enters, then run that, maybe...

 

[Alexandre]

Maybe conside using an ADO recordset based on your query. The MaxRecords property will allow you to limit the number of records that can be returned by the recordset object. You have to set this property before calling the Recordset's Open method.

Alex