Possible corruption? Listbox based on query not populating, yet works manually

[jess.42]

Hello! First and foremost, I have searched and read extensively. ;-)
I have also been playing with this for about four hours.

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. It just won't populate itself when the form opens!

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

 

[jess.42]

Never mind!
Problem solved. I was so busy thinking the forms or tables were
corrupt, I didn't realize the DATA was probably corrupt. I deleted the
records and started over and it worked.

thanks,
Jess

There's 4 hours I'm never getting back!