Form does not display all the records in the table

[Tammy]

Hi,

We have a data input form, which includes a main form and a subform (the
subform is a tab control object). We are able to add records to the form and
the tables reflect the new records. However, the form is not displaying all
the records. We have 25 records in the table, but only 4 of them show in the
form object. I checked to see if there was a filter applied, but there isn't.

I am baffled on this one. Any suggestions on where to search for the cause?

Thanks so much.

 

[Tammy]

I met with the user, here is a little more info...

The user entered one record in the form to test the database, and everything
worked properly. She closed the database and got back into it on another day.
When she opened the database, the record she previously entered was not
showing in the form. It was, however, displayed in the table. At this point,
she entered 20 more records through the form. She could see the number of
records, as she was entering them, on the record navigation bar (record 3 of
3, 4 of 4, ect.). Closed the database, opened it on another day and the
records did not show on the form, only in the tables. She added 4 more
records on that day, through the form. These records are the only ones that
display in the form. These were added last week, database closed, then
reopened this week. The four records show in the form, the other 20 records
do not. She has not changed any properties, or permissions. The only macro
built into the database is for the "OnOpen" event - it opens the form with a
specific field selected.

Help???

Thanks!

 

[Tammy]

Okay, it turned out to be a join property issue. I'm posting my fix, in case
anyone else runs into the same thing.

When I checked the source (can't believe I didn't do that - dumb mistake!!),
there were only four records showing. So, that made me realize the problem
was not the form, but my source (a query). I ended up changing the join
property for my "parent" table to a left outer join (#2 in the join
properties). Now, all the records show.