Print Page | Close Window

SubformInContinuousForm.mdb (beginner)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=262
Printed Date: 11 Nov 2019 at 8:19pm


Topic: SubformInContinuousForm.mdb (beginner)
Posted By: Roger Carlson
Subject: SubformInContinuousForm.mdb (beginner)
Date Posted: 21 Jul 2008 at 10:55pm
 
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 
SubformInContinuousForm.mdb
 
The problem is that Access doesn't allow a subform to be embedded on a Continuous Form. The following is one solution.

Have an unbound Main form with two subforms. The first subform has the Continuous Parent Subform and the second has the Continuous Child Subform. You synchronize the forms in the On Current event of the Continuous Parent Subform by issuing a Requery for the Continuous Child Subform.

Download
Access 2000 (61 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/SubformInContinuousForm2k.zip - uploads/5/SubformInContinuousForm2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window