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