G
gestalt_98
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
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