I have an application that uses a subform where I need to query a lookup from another database, the previous builder used a criteria with a variable, but I  had to capture the "filter" in each row again, It worked very well. Now with the new builder I have the problem that I can not capture variables in the "criteria" field or at least not work well.

Has anyone solved a problem like this?

Thanks ....