Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2010 datasheet subform issue

Status
Not open for further replies.

Axworthy

Programmer
Aug 21, 2003
61
CA
This seems to only happen with users running Access 2010. If a form has a subform that is a datasheet, and that datasheet has an Order By set, it sometimes shows with no records. Alternatively, sometimes it shows the records in the datasheet (which is based on a query) but when I change parameters that will limit the query such as limiting it to show details from one supplier and requery the subform, it continues to show all records. If while this form is displayed I open the underlying query separately, it correctly shows the limited records. This seems to only happen in Access 2010. Access 2007 and 2013 users, either full version or runtime are not affected. Has anyone encountered this before?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top