I have a problem that causes me a headace :p
I have a form which I have attached a command button to. When command button is clicked the form is set to FilterByForm (or actually I re - open the same form and go to FilterByForm). When I go into FilterByForm I want the FilterByForm to reset and display no values (only headings). However, this is not the case.
This is the code I use:
Private Sub .....
DoCmd.OpenForm "Personal Information", acNormal, "", "", acNormal
Me.Filter = ""
Me.FilterOn = False
Please suggest me how to solve this?