I have a query that returns a large number of records. I would like a user to type a number in a form field that will run a query and only select that amount of records.

In the SQL view I can do this by:
'SELECT TOP XXX' but I would like this to be dynamic.


MTmace

Search here for Top the questions been answered on several occasions