Query with form criteria not working as expected

[setis]

Dear all,

I have a query pulling data from 2 tables. ClaimDataSheet and ProviderData.

It works good until I set a criteria on the query to pull only the info based on the ClaimID active on a selected Form.



There is a relationship between Provider ID from the 2 tables.


The criteria is the following [Forms]![ClaimsDataSheet]![ClaimID]

In the query results, I get the correct ClaimID, ProviderName but not the bank info that I need. I have no idea what I'm doing wrong

 

[mike60smart]

Hi

Can you upload a zipped copy of the Db??

 

[setis]

Hi

Can you upload a zipped copy of the Db??

I have a lot on corporate information and linked tables. I tried to create a simple Db from scratch to reproduce the error and it worked good. :banghead:

 

[setis]

I have a lot on corporate information and linked tables. I tried to create a simple Db from scratch to reproduce the error and it worked good. :banghead:

I have found out that the problem is limited to one specific provider. No idea why their info is not showing. It doesn't make sense



Thanks for the help