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?
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 Mike Lewis 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
- Thread starter Axworthy
- Start date
Similar threads
- Locked
- Question
