Here's the situation:

The form have a 3 pages page frame:
Page 1: edit fields and navigations buttons
Page 2: list of all available records in a grid
Page 3: filtering options

They are many different combination of filtering conditions that the user can make.

On what should I base my form: a view or a SELECT-SQL?

A SELECT-SQL seem easier to use, but I can't edit it directly. A view would be more appropriate to do the editing, but the filtering options are bothering me. How can you build a view with changing criteria? Build a view programmaticaly? If so, would I need to initialize every fields "RecordSource" property everytime the filter is changed?

I need your advise on this.

TIA