[AccessD] Referencing Field on a Tab Form

That would work as well.  Thanks.

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 10:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
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