How do I limit the display of an Access subform to 10?

1
votes

I have multiple combo boxes in my form (Industry, Incorporation_Date, OperatingRev), and a search button which filters the subform (as a datasheet) based on the selection of each combo box. How do I limit the display of the subform to only 10 records (by Top 10 of Operatin Revenue)? Currently it is displaying all records available with the filter.

Appreciate any help, thanks!

1
mysqlsqlms-accesssubform

1 Answers

0
votes

In the Record Source used for your subform, your query should look like 

SELECT TOP 10 FROM …
ORDER BY ...

This post discusses more about using this: How to select top 10 in Access query?