[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