I have an application in MS Access 2003, which has a form and a subform. The subform displays, in its detail section records. I want to restrict the display of records of subform to top N records. When I use the query "select top 10 * ...", it executes successfully in the query editor window but when applied as the form's source property, it does not return any record. If the same form is used independently (not as subform), the top N query works just fine. Any help please why the top N query is not returning any records in the subform?
May 18, 2009 4:27 AM
July 16, 2009 4:52 PM