[AccessD] Referencing Field on a Tab Form

Since the main form didn't have - didn't need - a record source, that's
actually what I did as part of a workaround.  

However tab 1 needs that subform because I need the header and footer
sections.  So there's a problem keeping the memo field on tab 3 synchronized
with the record selected in the subform on tab 1.

So in the current event of the subform I set the filter of the main form to
the PK of the subform.  (I'm sure there's a better way.)

Then, as luck would have it, the record source for the sub-form on tab 1 is
actually a temp table I create when the form is opened, so when the memo
field on tab 3 gets changed I have to use a little DAO to put the field into
the source table where it belongs.  There are no editable fields on tab 1 -
it's used to select a shipment for a bill of lading. (Sigh)  

It works, but it's not very straightforward.  I'd still appreciate knowing
how to bind a text box on a tab to a recordsource on a sub-form on another
tab.

Thanks

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Monday, January 29, 2007 10:03 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

--
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