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

 

Valerie-

The simplest way is to have an unbound hidden text box on the outer form where you can place the appropriate SystemID to be referenced by the Link Master Fields property of the other subforms.  In the Current event of the form on Tab A, copy the current SystemID to the text box on the outer form.  You may also need to do a Requery of the other subforms after you do that.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Sep 16, 2014, at 6:32 PM, vs@cornerwebsite.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

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

.

__,_._,___