Subdatasheet (1 Viewer)

Is there a way to link a sub-datasheet to and existing datasheet that is linked to the main form? For example, my main form is called Events it show the Name of the Event, contact info an dates, then my sub-form which is in datasheet view, has the task of the event, i.e, security officer, police, medical. Then I want to link another sub-form to the first sub-form so when I click on one of the rows in the first sub-form the second sub-form with show rows of data the correlate with the one row in the first sub-form all the while still in the main form?

See this link for a method.

Thanks Sean, but I must be doing something wrong. I can get the Master form and ID to link to the first sub-form, but I cannot get the second sub-form to link to the first sub-form. Ant Ideas?

David

What did you try? Did you add a text box control to the main form and use it as the Master link source for your second subform?

I just realized right before you sent me a message that is what I forgot, works like a charm! Thanks!!