Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Mon Jan 29 16:30:44 CST 2007
Mark: The third tab is not a sub-form but has just a bound text box. But I think your approach will work if I put the bound text box on the third tab into a sub-form. Thanks Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Monday, January 29, 2007 1:33 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Referencing Field on a Tab Form 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://ima gine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=hmtagline -- 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