[MS_AccessPros] Re: Working with Tab Control and subforms

 

Hi John,  That worked as a charm.  I am using the text box on the main form to keep track of the billing id.  Thanks for the help.
Rod

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Rod-

There used to be a nice example of this in the Northwind sample database, but it has disappeared.  The basic technique is to put a hidden text box control on the outer form that has a Control Source something like:

=[First Subform].Form![BillingID]

Then make the Link Parent Fields property point to both the taxpayer ID and this text box.  The protest record for the current taxpayer AND the selected billing line will show up in the second subform.

Also consider building a subform inside the first subform.  If the first subform is in Datasheet view, you'll see a little plus sign next to each row for a billing.  Click the plus sign to reveal the associated protests.

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 Apr 18, 2014, at 6:18 AM, <desertscroller@...> <desertscroller@...> wrote:

I have a form which is the parent to a set of subforms contained in tab control.  I understand the linking of the subform to the parent.  Everything works great at that point; however, is there a way to also have one of the subforms linked to another subform.  Example:  the parent form is associated with a taxpayer (contains all the identifying information about taxpayer) and one of the subforms contain information about billings associated with the taxpayer.  A second subform contains info about any protest associated with the billing.  Currently, the protest subform is only displayed with the billing form shows that a protest is associated. 
All the forms (parent and subforms)  are linked with a taxpayer id field.  The protest subform is only shown when the billing form indicates a protest, these two forms have a current field (billing id).
I am trying to ensure that the proper protest is displayed on the form for the selected bill.  Multiple bills can be associated with the taxpayer and protests may not be filed for each bill.
Hope I explained the issue and hope there is an easy solution.  Working with MSAccess 2010 on a Windows 7 system.
Rod

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___