--0-126249883-1017101357=:56799
Content-Type: text/plain; charset=us-ascii


Thanks all for your input. Most suggestions were to simply make the control invisible. That works for all views except datasheet
view. But following the same simple concept, I thought about programmatically hiding the columns as you would in Excel. It works.
It's simple. Thanks again.
  ProDev <prodevmg@y...> wrote: 
Hi Leonard, 
That dosen't seem to work on a subform that is in datahseet view. 
  "Malczynski, Leonard A" <lamalcz@s...> wrote: Why not keep the controls on the subform but make them Visible = False,
tehn based on event triggered in the main form make them visible.


-----Original Message-----
From: ProDev [mailto:prodevmg@y...]
Sent: March 25, 2002 1:13 PM
To: 'MS-ACCESS-L@l...'; AccessDevelopers
Subject: Dynamically Change a Subform


I am in the need of adding or deleting fields from a subform
(programmatically) based on criteria on the main form. Does anyone have any
ideas?

Lonnie Johnson, ProDev, Builders of MS Access Databases
Let us build your next MS Access database application. 
http://www.galaxymall.com/software/PRODEV


Send and Receive payments for free with PayPal:
http://www.paypal.com/refer/pal=Y6TYF7YF8E2JG




_____ 

Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®



Lonnie Johnson, ProDev, Builders of MS Access Databases
Let us build your next MS Access database application. 
http://www.galaxymall.com/software/PRODEV 

Send and Receive payments for free with PayPal:  http://www.paypal.com/refer/pal=Y6TYF7YF8E2JG 


---------------------------------
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®

Lonnie Johnson, ProDev, Builders of MS Access Databases
Let us build your next MS Access database application. 
http://www.galaxymall.com/software/PRODEV 

Send and Receive payments for free with PayPal:  http://www.paypal.com/refer/pal=Y6TYF7YF8E2JG


---------------------------------
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®