combo box based on another combo box problem

[vangx222]

Hi. I received my example of how to create a combo box based upon another combo boxed from here:

"[URL unfurl="true"]http://office.microsoft.com/en-us/access/HA011730581033.aspx"]

My problem is the criteria part. I put this

[Forms]![Diagnosis]![cboDiagnosis]

in the criteria section like the website suggested. It works perfectly fine when I open the [Diagnosis] form (where the combo boxes are situated) HOWEVER, the [Diagnosis] form will actually be a subform within a bigger form name [Mainfrm].

When opening the Mainfrm, I received a

"Enter Parameter Value for [Forms]![Diagnosis]![cboDiagnosis], popup".

I'm assuming its becase of the syntax differences. Please help me out someone!!!
Thanks in advance.

 

[Remou]

You refer to a subform like so:

[tt][Forms]![Diagnosis]![subform contolname].Form.[cboDiagnosis][/tt]


See

http://www.mvps.org/access/forms/frm0031.htm

for more information.