[AccessD] Referencing Field on a Tab Form

Great solution A.D

I'm a big fan of "Thinking outside of the box"...."More than 1 way to skin a 
cat"...etc...

As always you impress me.

Thanks,

Mark A. Matte


>From: "A.D.TEJPAL" <adtp at airtelbroadband.in>
>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: Wed, 31 Jan 2007 23:38:58 +0530
>
>Rocky,
>
>     In that case, one possible alternative could be to make the first 
>subform itself a tabbed form. It would be a codeless solution.
>
>     If acceptable, the subform located on first page of tab control 
>belonging to the parent form will have its own tab control with two pages. 
>The bound memo field will be located on second page of suform's tab 
>control, while other bound fields would be located on first page of 
>subform's tab control.
>
>Best wishes,
>A.D.Tejpal
>---------------
>
>   ----- Original Message -----
>   From: Rocky Smolin
>   To: 'Access Developers discussion and problem solving'
>   Sent: Wednesday, January 31, 2007 20:24
>   Subject: Re: [AccessD] Referencing Field on a Tab Form
>
>
>   A.D.:
>
>   That'll work.  But they also need to edit that field and update it back 
>to the table.  I worked around the problem with a few lines of DAO code 
>updating the table directly in the after update event.
>
>   Any slick way to bind that field on the third tab to the recordsource on 
>the subform on the first tab?
>
>   Thanks and regards,
>
>   Rocky
>
>   -----Original Message-----
>   From: accessd-bounces at databaseadvisors.com
>   [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.TEJPAL
>   Sent: Wednesday, January 31, 2007 6:34 AM
>   To: Access Developers discussion and problem solving
>   Subject: Re: [AccessD] Referencing Field on a Tab Form
>
>   Rocky,
>
>       For sake of illustration, let the name of memo field in record 
>source of subform on first page of tab control be "Remarks". Place an 
>unbound textbox named  "TxtMemo" on third page of tab control.
>
>       Put the following code in current event of the subform belonging to
>   first page of tab control:
>
>   Private Sub Form_Current()
>       Me.Parent("TxtMemo") = Me.Recordset.Fields("Remarks")
>   End Sub
>
>       With the above measures, text box "TxtMemo" on third page of tab 
>control will always display the contents of memo field pertaining to 
>current record of the subform on first page of tab control.
>
>   Best wishes,
>   A.D.Tejpal
>   ---------------
>
>     ----- Original Message -----
>     From: Rocky Smolin at Beach Access Software
>     To: 'Access Developers discussion and problem solving'
>     Sent: Monday, January 29, 2007 22:50
>     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

_________________________________________________________________
Get live scores and news about your team: Add the Live.com Football Page  
http://www.live.com/?addtemplate=football