Please help me with the syntax for this stLinkCriteria. I have a main form with two subforms. Subform1 is in datasheet view and shows a few columns from the Classes table. When I click on a Class Row in the datasheet, I want to show the detail for that class in subform2. I've been going around in circles with this silly problem for 10 days, with no success. I guess I haven't asked the right question. I've tried using Link Child Fields, and Link Master Fields, with no success. Perhaps I can achieve my desired end with some VB, based on an OnCLick event in subform1. What would be the stLinkCriteria and DoCmd to show detail in subform2. The Primary key to the Classes table is ClassID. stDocName = "subform2" stLinkCriteria = ??? DoCmd ???