Problem with subform and criteria of query

[capsula4]

I have this subform:

FRUIT(combobox) VARIETY(combobox)

Variety combobox depends on FRUIT.

So VARIETY combobox comes from a query which has a criteria id related to what it's being chosen at FRUIT combobox.

So far so good...

The problem comes when I use this form as subform, it asks me for "Forms!MainForm!Fruit" as if it is a PARAMETER... do I have to add something special to the criteria thingie? (Forms!MainForm!Fruit)

 

[namliam]

Yes..

You can find the correct syntax by opening the query and the form.
Then in the query "build" your criteria

 

[capsula4]

Oh lol!!

Thanks a lot!! I have the habit to edit subforms on new window since I find it easier but never realised it could bring up those problems.

Thanks again!