Basing one combo box on another - doesn't work in subform

[china99boy]

hello... I have a form with 2 combo box. The second combo box items are limited based on the selection in the first. Everything works great on the form, except when I embed this form on another. As soon as I make a choice in the first combo box, and then try to select something in the second box I get a pop up box called "Enter Parameter Value" shows up with "Forms!frmTracking.cmbTracking.Value"

The form that I have it embed to is called frmMain. Below is the sql for the query. Can you guys guide me to what I am missing? Thanks in advance.

SELECT DISTINCT tblMtgType.mtgType, tblMtgType.ltv, tblMtgType.ltvDescription
FROM tblMtgType
WHERE tblMtgType.mtgType =[forms]![frmTracking].[cmbTracking].[value];

 

[arnelgp]

since your form is now a subform you include the main form name in the criteria:

WHERE tblMtgType.mtgType =[forms]![frmMain]![frmTracking].Form![cmbTracking].[value];

 

[china99boy]

Thank you so much for your reply. I tried that before and just did it again but go similar error.

Forms!frmMain!frmTracking.Form!cmbTracking.Value

 

[arnelgp]

remove the .Value from your query.

 

[china99boy]

After making the recommended changes, my query now looks like this and still get the same error.

SELECT DISTINCT tblMtgType.mtgType, tblMtgType.ltv, tblMtgType.ltvDescription
FROM tblMtgType
WHERE tblMtgType.mtgType =[forms]![frmMain]![frmTracking].Form![cmbType];

 

[arnelgp]

we have combo cmbTracking before not cmbType

 

[china99boy]

That was just a typo. But it is correct and still producing the same results. Sorry for the confusion

 

[arnelgp]

i re-created you scenario, but im producing the correct result.
is it a Navigation form that you added to?

 

[china99boy]

I was able to create a new dummy dba and tried it out and it works great with what you provided. But it doesn't work on my existing forms. Not sure what you mean by a "Navigation form"

 

[arnelgp]

if it is not too much can you post your db, so anyone can look and a a fix on it.

 

[china99boy]

Hi....I was able to find out what my problem. I was using the name of the form but, the expression was looking for "ENTRY FORM" which I had as the caption for the form. But I still couldn't do it without your help "arnelgp" Thanks for your time.