Mark A Matte
markamatte at hotmail.com
Mon Jan 29 15:33:19 CST 2007
Rocky, Maybe I don't clearly understand the issue...but Here's what I got: 1. You have 3 tabs and 3 subforms. 2. You want the 1st and 3rd tab to show different fields from the same record I think I got that effect setting the 3rd tab subform recordsource pointing to the same table as 1st tab...with criteria of ID of tab 1 "(SELECT DISTINCTROW tblTest1.ID, tblTest1.Memo FROM tblTest1 WHERE (((tblTest1.ID)=[Forms]![Form2]![tblTest1 subform].[Form]![ID]));" Then I set the OnChange property of the tab control to "Me!3rdTabSubform.Requery" I'm not sure...but I think this gets the effect your looking for. But something I learned while doing this...you can set the "LinkChildFields" on the 3rd tab subform to the field on the 1st subform manually...the effect was slightly different...any new record I created on the 3rd subform would have the same ID as the record selected on 1st tab...but not stay in sync. Hope that helps, Mark A. Matte >From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "'Access Developers discussion and problem >solving'"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Referencing Field on a Tab Form >Date: Mon, 29 Jan 2007 12:19:18 -0800 > >Since the main form didn't have - didn't need - a record source, that's >actually what I did as part of a workaround. > >However tab 1 needs that subform because I need the header and footer >sections. So there's a problem keeping the memo field on tab 3 >synchronized >with the record selected in the subform on tab 1. > >So in the current event of the subform I set the filter of the main form to >the PK of the subform. (I'm sure there's a better way.) > >Then, as luck would have it, the record source for the sub-form on tab 1 is >actually a temp table I create when the form is opened, so when the memo >field on tab 3 gets changed I have to use a little DAO to put the field >into >the source table where it belongs. There are no editable fields on tab 1 - >it's used to select a shipment for a bill of lading. (Sigh) > >It works, but it's not very straightforward. I'd still appreciate knowing >how to bind a text box on a tab to a recordsource on a sub-form on another >tab. > >Thanks > >Rocky > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy >Sent: Monday, January 29, 2007 10:03 AM >To: 'Access Developers discussion and problem solving' >Subject: Re: [AccessD] Referencing Field on a Tab Form > >Rocky, > >You could bind the main form to the table with the memo field and not use >subforms on the first and third tab. Wouldn't work if you already have the >main form bound to something else. > >Doug > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at >Beach Access Software >Sent: Monday, January 29, 2007 9:21 AM >To: 'Access Developers discussion and problem solving' >Subject: [AccessD] Referencing Field on a Tab Form > >Dear List: > >I have a tab form with three tabs. On the first tab is a subform bound to >a >table. On the second tab is another subform bound to a different table. >One of the fields in the table in the first tab is a memo field so I want >that to display that on the third tab. > >Is there a way to reference the memo field from the recordsource on the >subform on the first tab in the text box on the third tab and have it move >with the recordset on the first tab so the record selected on the first tab >shows the memo field on the third tab? > >MTIA > >Rocky > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > >-- >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.5.432 / Virus Database: 268.17.12/655 - Release Date: 1/28/2007 >1:12 PM > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com _________________________________________________________________ Laugh, share and connect with Windows Live Messenger http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=hmtagline