[AccessD] Continuous subform on a continuous subform

Too slick!  Thanks.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Wednesday, March 19, 2008 10:54 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Continuous subform on a continuous subform

Rocky,

I normally put an unbound (hidden) textbox on the main form, with its
Control Source set to the equivalent of:
=[Subform No1]![Primary Key field of subform 1]

And then, set the Link Master Fields property of Subform No2 to this
textbox.

That way, as you move from one record to another on Subform No1, the records
shown on Subform No2 will automatically be synched, without the need for any
code at all.

Regards
Steve

Rocky Smolin at Beach Access Software wrote:
> No, I couldn't do that because the sub-form - No. 2 is the one I 
> wanted to make a sub-form in sub-form No1.  But since they were both 
> continuous I couldn't.  So your idea was the right stuff.  But I have 
> to refresh No 2 (which is look only, no editing - makes things easier)  
> in the current event of No.1.  And it's working now that I changed No.2's
record source.
--
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. 
Version: 7.5.519 / Virus Database: 269.21.7/1335 - Release Date: 3/19/2008
9:54 AM