[AccessD] Continuous subform on a continuous subform

Charlotte Foust cfoust at infostatsystems.com
Thu Mar 20 09:37:58 CDT 2008


Yep, that's the way I do it too.  I just didn't explain myself well.
One of those hit and run posts. LOL

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Thursday, March 20, 2008 7:02 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list