[AccessD] Referencing Field on a Tab Form

I believe that WILL work.

Thanks

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Monday, January 29, 2007 9:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
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.12/655 - Release Date: 1/28/2007
1:12 PM