Hey John,

Well I was exploring the idea of creating views on the fly when I add something to a form that needs a new view I need to get the database and add the view then copy the view back...

Wadduthink?


>Hey John,
>
>OK, terminology check time! :-)
>
>Are you trying to create a View or just a cursor? If you are really trying to create a View that will become part of a Database, then I think your architecture needs to be reexamined and, possible, a parameterized View could be created and used instead.
>
>If you are trying to create a cursor with a simple SELECT statement, then consider doing it in the Init of the form, then set ControlSources as required to view (but NOT edit) the data.
>
>>If I create a View on the fly in a form how do I add it to the forms DE?
>>
>>Thanks