[AccessD] Referencing Field on a Tab Form

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