use of subform causes parameter prompt 2

[djdeuph]

Hi all,

I have a form that uses the cascading dependent combo boxes concept (choices in txt2 depends on txt1; txt3 choices depend on txt2, etc.) Everything is working great so far.

Then I decided to make this form a subform of another one to allow me to filter and navigate through the records more easily.

Ex. the cascading form has about 150 items. By placing it as a subform in the process form, I can navigate the items by process.

However, when I open this form/subform I get a prompt asking for the values in the cascading text boxes. This has something to do with my RowSource property, I think:

SELECT DISTINCT tblControlObjective.CtrlObjID, tblControlObjective.CtrlObjective FROM tblScopeProcess INNER JOIN (tblControlObjective INNER JOIN tblObjRiskGuidance ON tblControlObjective.CtrlObjID=tblObjRiskGuidance.CtrlObjective) ON tblScopeProcess.ScopeProcessID=tblObjRiskGuidance.Process WHERE (((tblObjRiskGuidance.Process)=Forms!frmControlDesign!cboProcessID.Value));

It works fine when I open the form independently of the form/subform idea.

Thanks!

Derek

 

[TheAceMan1]

How are ya djdeuph . . .

Realize . . . by using the form as a subform, your changing how you reference the form.

Referenced [blue]as mainform[/blue]:

[blue]Forms!frmControlDesign!cboProcessID[/blue]

Referenced [blue]as subform[/blue]:

[blue]Forms![purple][b]MainFormName[/b][/purple]!frmControlDesign[purple][b].Form[/b][/purple]!cboProcessID[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[djdeuph]

You got it! That was the issue. Thanks for your help!

Derek