[AccessD] Referencing Field on a Tab Form

What I have done in the past for a similar situation is to create a subform with the memo field only.  In the query of the Memo field subform reference the ID number for the first tab.
Do a refresh on the form when tab 1 is changed.

HTH

Jim 
jhewson at karta.com
 
-----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 11: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