Full Version: Remove Filter / Sort
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
ambaad
Hi there

I have a problem that when i open a form containing client details i have to press remove filter sort befor i can see any of the records, this is not a problem for me but i have other people in the company who use this datatbase and this is not acceptable to my boss. I have checked and i cannot see any filter on or anything that is making it filter.

Many Thanks
Adam
dashiellx2000
The easiest thing I can think of would be to remove any possible filters and sort on the open event of the form:

CODE
DoCmd.ShowAllRecords
Me.OrderBy = ""


HTH.
ambaad
thanks mate
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.