Access 2010: Unfiltered Form Not Showing All Records

[rothko26]

Hi all,



Hope you can help...

I have a form (frm_Navig) in an Access 2010 database which is formatted to show a list of records in data sheet view. The record source for frm_Navig is an unfiltered query (Qry_PartData), which is based upon a single table (tbl_PartData).

The table itself has 299 records, and when I run Qry_PartData it shows all 299 records as expected. So far so good.

However frm_Navig, based upon Qry_PartData, is only showing the first 198 records, despite having no filters set.
The oddity is that the record count at the bottom of the form indicates the correct number of records (299), but records 199-299 are not visible and cannot be found using the FindRecord function.

I've tried changing the form's record source to the original table (tbl_PartData), but again only shows the first 198 records, so presume this is a problem with the form.

To confirm there are no filters set and no criteria set on the table, query or form, and the information is pulled from a single query, based on a single table so there are no join issues.

Any help is appreciated as this is really confusing me.

Thanks,

Michael

[burrina]

Suspect problem is with form. Try creating a new form for test purposes and see what happens.

[rpeare]

Can you create a sample database and post it here for examination, I have never seen this behavior and I expect it's something to do with the form as well.

[ItsMe]

I will add that this is goofy and corruption should be suspect. I do have one question though. Why did you choose the name, "frm_Navig"? Are you using a Navigation Control/Form?

[rothko26]

Hi all,

I was definitely scratching my head over this one, and following burrina's advice rebuilt the form from scratch.
Rerunning the form and the problems have resolved themselves...so presume the original form was corrupt.

As the database itself is fairly simple, is this something I should be worried about?

Thanks again,

m

[June7]

Corruption of objects is not uncommon during development when changes are frequent. I had quite a few. Now that db is fully implemented and modifications are rare, not seen any corruption for couple years. Be sure to have a backup can revert to because the entire db can become corrupted beyond recovery. This happened to me a couple of times.

Is your db a split design?

[Missinglinq]

It's also a very good idea to go to Options – Current Database – Name AutoCorrect Options and untick all boxes in that section. Name AutoCorrect has long been associated with corruption during development.

Linq ;0)>