subform parameter input not linking properly
- From: "gestalt_98" <gestalt_98@xxxxxxxxx>
- Date: 29 Jul 2006 16:27:40 -0700
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
.
- Follow-Ups:
- Re: subform parameter input not linking properly
- From: John Vinson
- Re: subform parameter input not linking properly
- Prev by Date: Re: Truncating Numbers
- Next by Date: Re: Truncating Numbers
- Previous by thread: Re: Truncating Numbers
- Next by thread: Re: subform parameter input not linking properly
- Index(es):