Data from Table not showing in form correctly.

[Mitt1]

I have a customer form that contains data from tblCustomer, I also have a subform in my main form called sfrmCPartner (containig data from tblCPartner). When I run a query to search for a customer, the data from tblCustomer returns fine, but the data from the subform just returns the first record all the time. I have an associative entity that links data from tblCustomer and tblCPartner, there is no data in this link table and I'm not sure if this the problem.

 

[plog]

What is the data source of the form not showing correctly?

 

[Mitt1]

What is the data source of the form not showing correctly?

tblCPartner

 

[plog]

What's the source of the main forms data?

 

[MarkK]

The subform should show data from tblCustomerPartner, not from tblCPartner.