>The view is readonly and isn't updatable. The form that allows users to add records works directly against the table. There are 2 tableupdates done on the table. One in a control and another I added to force it. The view is used to allow a user to have a list of locations to select and click on it to select it. Then the form closes and places the user to the location they selected. The primary key is a automatically generated identifier because there are duplicate location information that will prevent finding the exact location.
After performing the TABLEUPDATE()s, do you subsequently requery the view?