Help I think I lost most of my records

[Guest]

I ran a filter, changed one field in one of the filtered records and clicked
the save, thinking I was saving the change to that record. The filter icon
went off when it saved and now my 1000+ records are only 17. What do I do???

 

[Guest]

If i understand your question correctly, then all it requires is that you go
up to the top of your window there and click on the "remove filter" button.
So far as i know, a filter never removes records, it only hides them. a
Query removes or changes which records actually exist in a table.

 

[Guest]

I had the filter on (definitely a filter, not a query). When I clicked the
save icon, the filter icon went off as if there is no filter on anymore.
There's no revert or undo changes or undo last save under file or edit--I see
no options.

 

[Guest]

Everything is okay--I don't understand it though, if anyone can explain...
The little filter icon was definitely off, no way to undo what I was seeing

 

[John W. Vinson]

Everything is okay--I don't understand it though, if anyone can explain...
The little filter icon was definitely off, no way to undo what I was seeing
on the screen (the 17 filtered records). Well I tried clicking on the
"filter by form" button and everything came back. I'm backing up right now!

A filter will not *DELETE* records from your table. It will only hide them
from view.

John W. Vinson [MVP]