[AccessD] Referencing Field on a Tab Form

Rocky,

You could bind the main form to the table with the memo field and not use
subforms on the first and third tab.  Wouldn't work if you already have the
main form bound to something else.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, January 29, 2007 9:21 AM
To: 'Access Developers discussion and problem solving'
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