I think what Bob meant is that you can parameterize the WHERE clause. For instance, if you view's where clause has LastName=?m.Last any time you use or requery the view you will get all records where LastName=m.Last. You can then change the value of m.Last to change which records are returned. If you need to change the SQL itself you'll need to recreate the view using CREATE SQL VIEW. This can cause problems if the DBC is shared among multiple users. You should either have each user have a separate copy of the DBC or you should use SQLEXEC() for queries that may change while the program is running. I ususally use SQLEXEC() for queries and views that return only a single record when the user decides to edit a record.

>With the view parameter you can get the SQL property
>but you can not change it