Possible corruption? Listbox by query not populating

[Kendertaunt]

Hello!
I have four (near) identical forms. I have four (near) identical queries.

The forms each have a (near) identical Listbox, which populates based on their respective queries.

Two out of the four forms work perfectly. The other two, the listbox is blank.

Here's the crucial factor on the query:
[Forms]![Test]![TestID]

The form in question HAS a field called TestID, and it is populated.

If I open the query manually and type "4", I will correctly get my result.

If I change the query and hardcode "4" in there, the listbox populates with it.

I have created a new database and imported everything. I have compacted. I have created a new form. I have even kept the same form, but based it off a different query, and it populated. I have re-created the query from scratch.

Everything is pointing to that one line, [Forms]![Test]![TestID], in the criteria, but I am at my wits end. Two out of four queries work just fine. The other two are not populating.

I would be happy with any advice you can give!
Thanks,
Jess

 

[Remou]

Please post the Row Source and / or the SQL for the problematic listbox.

 

[Kendertaunt]

Thanks for the reply!
I resolved the issue, it was corrupt data in the intersect table. I deleted the data, compacted, and all was well!