Print Page | Close Window

DynamSubFrm.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Hookom, Duane
Forum Description: Duane Hookom's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=14
Printed Date: 12 Dec 2017 at 2:58pm


Topic: DynamSubFrm.mdb
Posted By: Duane Hookom
Subject: DynamSubFrm.mdb
Date Posted: 23 Jun 2008 at 10:52pm
This Access 2000 mdb shows how to set the SourceObject of a subform control to a query. This solution will work with a crosstab that returns a dynamic number of columns. The DAO object library is used to change the SQL property of the crosstab to remove any parameters.
 
Download Access 2000: http://www.rogersaccesslibrary.com/forum/uploads/4/DynamSubFrm.zip - uploads/4/DynamSubFrm.zip


-------------
--
Duane Hookom
Microsoft Access MVP
Eau Claire, WI



Print Page | Close Window