[MS_AccessPros] Syncing Sub-Subforms with a Totals Sub-Subform

 

I have a tab control with 5 tabs.  Each tab contains a subform. 

The first tab displays a subform in datasheet style of ALL of the Systems

The other 4 tabs display a corresponding subform which lists information for only 1 System at a time.

As I move from record to record (System) on the datasheet totals subform, I would like the other corresponding subforms to sync to the same system.

For Example, If I am position on the second record in the datasheet (SystemB), then I would like to click on the Products tab and see the subform display information for only SystemB.

I am at a loss as how to do this.  I have tried GoToRecord, FindRecord, Changing linking Master/ChildFields, etc.  I keep getting errors or failures.

I have screen shots of database if needed.

SystemA ----------> Show System A on all other Subforms

SystemB-----------> Show System B on all other Subforms

SystemC-----------> Show System C on all other Subforms

Valerie

__._,_.___

---

Posted by: vs@cornerwebsite.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Yahoo Groups

New Improved Groups Search

Searching for new groups to join is easier than ever. We've honed our algorithm to bring you better search results based on relevance and activity. Try it today!

---

Improvements in Yahoo Groups Search

Searching for new groups to join is easier than ever. We've honed our algorithm to bring you better search results based on relevance and activity. Try it today!

---

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___