Unable to restrict the display to top N records in subform in Microsoft Access 2003

10 pts.
Tags:
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,
ASKED: May 18, 2009  4:27 AM
UPDATED: July 16, 2009  4:52 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following