Mark,

Does the view have a filter in the WHERE clause? If it does and if the record you added does not meet the criteria in the WHERE, it won't show up when you REQUERY().

>I've seen messages about views here on the UT. I decided to try using them and I *think* I understand their use and how to set them up, however, I seem to be missing one key element. Here's what I've done... I have a simple test table with a key (integer) field which is updated by code in my stored procedure (which works fine). There are then a few other fields, character data. I've created a local parameterized view based on a "status" field, which works fine. On the Update Criteria tab of the view designer I have chosen my key field as the "key", and clicked Update All, and checked the 'Send SQL updates' check box. But I'm having problems getting updates saved and showing up in the view after doing a requery. Here's what I'm doing in the command window...
>
>lcStatus = "Customer"
>SELECT vTest
>INSERT INTO vTest (firstname,lastname,status) ;
>VALUES ("Joe","Smith","Customer")
>= TABLEUPDATE()
>= REQUERY('vTest')
>BROWSE
>
>The new customer, Joe Smith, does not appear in the browse, however Smith's record DID get saved because it is in the base table with the correct values. So, why doesn't the new record appear in the view after the requery()?
>
>Thanks!