Why is one database returning info and other not?

[KristenD]

Can someone please take a look at the 2 databases and the queries qryOSHAbyJob in the one database and qryOSHAJob in the other database?

One will return the data I want and the other one only returns the last record entered.

I will attach the db's. I am working in A2007.

Thank you!!

 

[KristenD]

Both forms are the same I have checked all their properties. The code is the same for both pop up forms.

Once I get this query working for the Practice2 db I can go live with this portion as well.

Please help!!!!!

 

[KristenD]

I've gone through and done a side by side comparison and found the only difference so far is the event procedures for the from one is on load and the other is after update but when I click on the ellipses (...) it brings me to the VB screen but no code. Is there something that should be there that isn't?