I have a Customers form and I want to place in a subform that is based on a query that is based on a linked MySQL database table. I have created the form that will become the subform, and when opened, it displays everything correctly, but of course shows all records in the table. When I insert this form into my main form as a subform, I link the correct Child and Master fields, but when I open the form, the subform is displaying only 1 record for each customer I navigate to. I know for a fact that there are many records for each customer that should be listed.
I dont know if the following will help to determine the problem or not but I have noticed the following:
1. If I open the query that the subform is based on directly and use the filter on the toolbar, I get the same single result, but if I filter using the WHERE clause in the query design, I get the correct results.
2. I thought maybe this had sometihng to do with being linked to a MySQL database, so I imported the table directly into Access and tried the same thing and got the same results. I even tried stripping the query down to the basic "Select * From Charges" and got the same problem when filtering.
I know I talked about filtering in these last 2 paragraphs, but my main problem is the linking Master/Child fields only returning 1 record (unless that is essentially how that works which, would then make sense)
Any suggestions as to what can cause this?
I dont know if the following will help to determine the problem or not but I have noticed the following:
1. If I open the query that the subform is based on directly and use the filter on the toolbar, I get the same single result, but if I filter using the WHERE clause in the query design, I get the correct results.
2. I thought maybe this had sometihng to do with being linked to a MySQL database, so I imported the table directly into Access and tried the same thing and got the same results. I even tried stripping the query down to the basic "Select * From Charges" and got the same problem when filtering.
I know I talked about filtering in these last 2 paragraphs, but my main problem is the linking Master/Child fields only returning 1 record (unless that is essentially how that works which, would then make sense)
Any suggestions as to what can cause this?
