Cascading Combo Box Subform Problem

[Fozi]

Having a problem getting my cascading combo boxex to work when accessed as a subform within a master form.

In short users pick an activity which then dictates what shows up in the subcategory control.

All works fine when working directly within this subform. However when trying within the master form I get an "Enter Paramater Value" dialog box for the control Activity.

All help greatly appreciated

Fozi

 

[rainman89]

make sure you are referencing the controls correctly. It is different when using a subform

see here Clicky

 

[Fozi]

Thanks Rainman, that was it!

In my sql statement I needed to make reference to the master form and subform which I wasn't doing.

Works now!

Cheers for all your help