vba search in subform working fine but.. TmprryQryFrLnkFldsCrtn0123456789

[Susy]

Hi guys,

I could ignore this, I guess, but now and then I get this empty weird query... "TmprryQryFrLnkFldsCrtn0123456789".

I have this search form which filters data from a subform. I have been writing on the internet and nobody really knows why or how is this query created.

If I delete the query, only a record is shown in the subform and all search functionality is gone.

If I leave it there, nothing happens and I can keep working as if it were not there.


I even change my sql statement to Select Distinct *... from Select *... but it did not helped.

Funny thing though, when I rewrite the code again, after deleting this weird query, the search form shows all records.. but then at some point the weird query appears... I don't get it.

Should I just leave it? or



Should I take care of it? But, how?


Regards and nice Sunday!

[orange]

Post a copy of your database with enough records to show the problem.
Tell us how to get to the problem situation clearly.

[Susy]

Hi Orange, thanks for your fast reply. Unfortunately I wont be able to do that. It is a pity.
Thanks anyway.

But, is this query so bad?

[orange]

??? You can make a copy; then get rid of all your real data; add a few records for Porky Pig, Daffy Duck etc.
Make sure the error is still there, then post the dummy database. need to see the situation to offer more focused advice.

I have no idea what "TmprryQryFrLnkFldsCrtn0123456789" is nor whether it is important to your database/application.

[Susy]

Ok, I will do!

[Susy]

Orange, I found the problem...

the main form was not unbound but was referring to a table...

"The key point is that you want the main form UNBOUND and you want the controls where you put in criteria to trigger the filtering of the subform."

Thank you all!