[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

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.17/661 - Release Date: 1/30/2007
11:30 PM