Mike,

You will have to re-assign the recordsource and all of the controlsources in the grid after you create and open the view.

>Hi,
>
>is it advisable that everytime you choose a specific item in a combobox, it will trigger a command that will create a sql remote view?
>
>The idea is that a pageframe that has 2 pages each contains a grid.
>
>everytime the user clicks item A, the active page is set to 1. If the use clicks on item B in the combobox, a filter form will pop up. The user will encode or select his/her desired filter conditions and upon clicking the ok button, the program will then activate page 2 of the pageframe and will proceed in creating SQL remote view named(dispatches) depending on the filter conditions the user selected?.
>
>Note: The grid in page2 has a recordsourcetype = alias and recordsource = dispatches
>
>
>Thanks in advance...