Form without Data

[Wheezy]

My main database form has worked perfectly for 8 years, and suddenly quit showing the data in the table.
If I know the name I am looking for, I can search it.
But, when I open the Form that used to have all my clients and their info listed. I get a blank form, with a 1 of 1 showing at the bottom.
Any idea how to get it to show all my people again?
Thank you.

 

[Uncle Gizmo]

Is there anything you’ve done that could have affected it?
If there’s nothing you’ve done, then I would suggest you eliminate the possibility of corruption by creating a new blank database, and from this new blank database import everything from the old database. Then try and access your data in this new database and see if it works.

I’m sure you know this, it goes without saying for most people, but make sure you have backups before you do anything!

 

[missinglinq]

...when I open the Form that used to have all my clients and their info listed. I get a blank form, with a 1 of 1 showing at the bottom.

This sounds suspiciously like the Form's Data Entry Property has been set to Yes, which doesn't allow the displaying of existing records, but only the addition of new records.

Linq ;0)>

 

[Wheezy]

Yes, that was the trick. I didn't want to have to block other users from the system, but I guess I'll have to now. THANK YOU, very much!

 

[missinglinq]

Glad we could help!

Linq ;0)>