Home > IT Answers > Microsoft Windows > Unable to restrict the display to top N records in subform in Microsoft Access 2003
Zafarkhurram
10 pts.
 Unable to restrict the display to top N records in subform in Microsoft Access 2003
Microsoft Access 2003, Microsoft Access 2003 forms, Microsoft Access 2003 subforms
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? Thanks,

Software/Hardware used:
ASKED: May 18, 2009  4:27 AM
UPDATED: July 16, 2009  4:52 PM
RELATED QUESTIONS
Answer Wiki:
If you are displaying data from a two different tables are queries on the two forms then there must be a relative field which binds the subfom with the main form. Check that the top 10 records are being filtered by the common field, if yes then the first record of the main form falls into the filtered records or not.
Last Wiki Answer Submitted:  July 16, 2009  4:52 pm  by  ITCogent   115 pts.
All Answer Wiki Contributors:  ITCogent   115 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _