Peter Vogel discusses setting the RecordSource property of a subform dynamically to improve an application’s performance. He also answers some thorny questions about using ADO to update a view (you can’t). Read Access Answers
I have been programming and supporting Microsoft Access databases since 1995. In 2007 I received the Access MVP award from Microsoft because I waste too much time writing newsletters and blogs. Why not sign up for one of my newsletters at http://www.vb123.com.au and look for newsletter on the left.