Hi All,

I have built a user form where the user types something (unique value), presses a "find" button, and the form shows the relevant record from the database sheet each filed from the relevant record is presented separately, like in an MS Access form…)

Unfortunately, I cannot attach a sample here because it is a foreign language and I really can't convert the whole thing to English right now (not to mention the fact that it contains confidential commercial data).

Anyway, as I have mentioned, the form takes its data from a rather large database and what I am now trying to do now is simulate on the form a two criteria "auto filter" , and let the user scroll through the filtered data – from within the form - with a slider or next-prev buttons.

Can someone please suggest to me a code that will filter the database and then populate to the form only the filtered data, and let the user scroll back and forth?

Thanks in advance