Problem with records in a Linked subform

rmccafferty · May 11th, 2009, 06:49 PM

I am trying to link a subform and see all of the records. I am doing something wrong and cannot figure out what it is. Can you think of anything I am missing in the below?

The main for and subform are based on tables. (I do not want to use queries because I want to be able to do data entry in the subform).
They are related by a customerID field showing all records in the subform's table that have a valid customerID in the main forms table.
I ran a query that shows all fields in the subform's table where there is an existing customerID in the main form's table. That is, I am trying to see what I find in the "sub table" if I run a query with the same match as I use on the form level to link the two forms.
This query shows me all records in the subform (24 of them in the test stage).
When I run the subform, I of course see all 24 records.
When I put the subform into the main form, with the link of the same two tables using the customerID field, I only see 6 of the records.

Getting desperate, I then copied record 1 that was showing up everywhere, from the top line of the base table for the subform and pasted it at the bottom of the table. And then deleted its original from the top line of the table. Surely it would still show up because the copied records is identical to the one I deleted? NO! The copy does not show up.

So it would seem it cannot have anything to do with the link or the base records. What would cause some records to show up and not others?

SerranoG · May 13th, 2009, 09:57 AM

Hmmm... I don't see the need for the query relating the two tables to put on your subform. Just set the record sources of each form to their respective tables. When you place the subform into the main form, Access will ask you to set the Parent / Child property of the subform. It is there you link the customer ID from the main form (parent) to the subform (child). When you scroll through the main form, the subform's records will then automatically filter. There is no need for a separate query.