>>my code..
>>CREATE SQL VIEW myview AS SELECT * FROM mytable WHERE &string
>>I get a selected group of records.
>>Then I BROWSE with BROWSE FIELDS
>>
>>The next time I do the same thing, I sould get another
>>selected group of records, but the computer uses
>>the previous VIEW? Why?
>
>Open your database that contains the view with the OPEN DATABASE command. Then type:
>
>? DBGETPROP("myview", "view", "sql")
>
>This will show you what the view SQL is stored as. It should show that it expanded your "&string" and stored it in the view. Therefore, each time you use the view, it will return the same data set. This is most likely not what you want.
>
>Try using parameterized views instead. If you post what "&string" contains, I can help you with the syntax.
>
>-Doug-
thanks for the tip. I found my problem. My ControlSource was set to
table->fld. It is now set to fld.
thanks again.