how rewrite queryfilter to refer to a control in a subform? (1 Viewer)

[wcoast]

Hi!

I've developed a form to be standalone. It's based on a query with filter like this:

Like "*" & [Forms]![myForm]![Fltr1]

(The Fltr1 is a combox value.)

Now when i place the form "myForm" as a subform in another form (FormMain), the query does not give me any data.

How do i refer to the filter from the query??

Any help will be much appreciated!

thanks

 

[jkl0]

Try adding your subform name.

Like "*" & [Forms]![myForm]![YoursubfrmName]![Fltr1]

Hope this helps.

 

[wcoast]

Yeah! It worked