subform parameter input not linking properly

Tech-Archive recommends: Fix windows errors by optimizing your registry



I have a cascading product picker that relates 5 categories each
providing a pick list related to a previous parameter. The picker
works when placed in a form by itself, but the parameter doesnt pass
when the combo-boxes are nested within the subform. I am currently
passing sql with the following language:

SELECT allWithIDs.cat05 FROM allWithIDs WHERE
(((allWithIDs.Product_family)="Drapery") And
((allWithIDs.Product_Type)=Forms!SODetail_drapery_entry_subform!Product_Type)
And ((allWithIDs.cat01)=Forms!SODetail_drapery_entry_subform!cat01) And
((allWithIDs.cat02)=Forms!SODetail_drapery_entry_subform!cat02) And
((allWithIDs.cat03)=Forms!SODetail_drapery_entry_subform!cat03) And
((allWithIDs.cat04)=Forms!SODetail_drapery_entry_subform!cat04)) GROUP
BY allWithIDs.cat05;

When the main form is live I get a parameter dialogue, meaning the
parameter wasn't passed. should the logic look more like:

Forms![MAIN_FORM]!SODetail_drapery_entry_subform!cat01

instead of Forms!SODetail_drapery_entry_subform!cat01

??

Any responses would be much appreciated.

lc

.