Web Development

Ask something
Discussion Locked

Can't View Data

0 helpful
7 replies

by djpinson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have created a dbase in Access 2000. I've entered data in the form and exit. When I open the form to view the records I can only see 11 of the 15 records entered.

When I check the table all the records are there.. Any idea what I may have donewrong?

7 replies

by radiic

I would take a look at the table in design mode and look for your primary index ( designated by the key). I am guessing that maybe you used the wizard and let it create a primary key for you. The default is to index with no dupes. I am then guessing that 5 of the 15 items you have, whatever field you indexed on has the same value, and it will show you only one of them when you look at it through your form.

Hope that Helps
Rad

by estebandelatorre

Your form may by filtering some records or is being feed by a view (a join from various tables). These view may have a filter criteria.
Hope it helps.

This discussion is closed to new replies.