>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...

did you also marked the Key field as updatable?

Arnon