combo box to add certain fields into a subform

[wwwredback via AccessMonster.com]

Hi All,

I have asked this on a few occasions but I am now thinking it is not possible.


I am trying to only use certain fields in a subform depending on what is
selected on a mainform combo.

Can anyone please point me in the right direction.

Thanks

James.

 

[John W. Vinson]

Hi All,

I have asked this on a few occasions but I am now thinking it is not possible.


I am trying to only use certain fields in a subform depending on what is
selected on a mainform combo.

Can anyone please point me in the right direction.

If you want to *redesign the structure of the subform* for each combo box
selection, it's not really practical. It could be done, but you'ld have to
switch the form into design view, change its controls, save it, reopen it...
it'd be VERY slow and would very rapidly bloat your database.

Why not have several pre-defined subforms, and use the afterupdate event of
the combo to change the SourceObject of the subform control?