Navigating a Filtered List

[albrad84]

I have a form that contains a pretty large list of items and several columns and the list can be sorted by each of these columns. When a user double-clicks on a particular item, another form pops up that lets the user view/modify the item. The problem I'm having is that I still want to be able to use the navigation buttons in that second form, but right now its just saying 1 of 1 (Filtered).

The way I'm applying the sorting is by updating the Rowsource field of the list with an "Order By" statement

Any help would be appreciated

Adam

 

[KenHigg]

Can you do a button on the second form that sets the allowfilters property to 'no'?

 

[albrad84]

I tried setting the form's "Allow Filters" property to no, but that didn't seem to do anything.

Preferably, I'd like to keep the filter/sorting, but still be able to navigate through all of them. I tried putting a ShowAllRecords statement in there, which worked, but took me back to the very first record and not the one I clicked on.

Any other suggestions?