Help with stLinkCriteria

[Bob Richardson]

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 ???

 

[Allen Browne]

For an example of how to build this kind of form, open the Northwind sample
database, and the Customer Orders form. Follow that example.