I created a form with datasheet view, and I use this extensively, whenever I searched I only clicked the header and choose the item i like.
What I need is to create a button to return back all the record in the screen.
How can I do this.
Trident
I created a form with datasheet view, and I use this extensively, whenever I searched I only clicked the header and choose the item i like.
What I need is to create a button to return back all the record in the screen.
How can I do this.
Trident
click the TOGGLE FILTER on the toolbar to turn off the filter and show all records again.
Thanks for the answer, however, that is what I was avoiding to do, i am trying to reduce the number of clicks to 1.
Forms![frmMain].RecordSource = "qryOriginalQuery"
Forms![frmMain].Requery
clicking the Filter button IS 1 click.