I have a search field in my database so I can searh my records by social security number. Well after the search is finished, it obviously it displays the record I searched for. Well, it seems to place a "filter" on the databse and in order for me to display all records again i have to close out of the form and reopen it again. So it displays record 1 of 1000 instead of 1 of 1 after I complete the search.
Is there any kind of command button I can use to remove the "filter" after I use my search field? This isn't a filter that you can remove in the records menu.
this did not work unfortunately. basically i have a search field with this code.
If Not IsNull(Me!FSS) Then
Me.RecordSource = "Select * from [Claim Tracking System] where [Social Security] = '" & Forms![Claims Tracking System]!FSS & "'"
when it searches it obviously brings up what i searched for and if it does not find anything it leaves a black record and displays 1 of 1. Well, I may need to use the find and replace feature to search the database manually for different criteria. Well, I am unable to do that because after I use my search field above, the database automatically seems to "filter" the recods and does not display them all.
How can I reset the "form" or search option to display all of my recods without closing out of the database?
I prefer to do this via command button, but am not sure of the proper code.