Thanks, Jeff.

More questions: Does this happen if you put a TableRevert() immediately before the View Requery? Also, can you check the view at this point with GetFldState(-1) to see if there are ANY changes being made you are unaware of?

Barbara



>Barbara,
>
>Answers are below
>
>>Jeff,
>>Some questions (in part repeating what Ricardo asked)
>>
>>1) Does this happen when you have NOT changed data in the grid?
>
>No only when I change a field in the view and without moving off the field click on the dropdown list
>
>>2) Are your tables/views row or table buffered? If row buffered then Tableupdate() will be called by VFP whenever you change rows.
>
>Tables - not buffered
>Views - Table buffered
>
>>3) Is there any outstanding unchanged data ANYWHERE when you get the error?
>
>Only the field that I just changed. This does not happen on a certian field I can change any field and get the same error
>
>>4) What code is in the GotFocus, When and InteractiveChange methods for the combo? Just to requery the view?
>
>Nothing, All code is in the click method
>Click method - The first thing that I do in the click method is run the method from the grid that has the tableupdate() call in it. Then set the record source of the grid and columns to the table the view is based on (same structure so I do not loose my columns) Then change the view or requery (use v_deal alias curview) then reset the record source of the grid and columns back to the view.
>
>I have also tried putting this (the update method) in the lostfocus of a field in the grid so I know that the table is being updated before I change views or requery()
>
>>5) If it's a parameterized view, how is the parameter set?
>
>The parameter is what is selected in the dropdown list so in the click method
>p_curview = this.value
>
>>6) If necessary do you do a combo requery (to refresh the data) after doing a view requery? This is particularly important, as the data in a combo must be requeried to reflect the underlying data if the view/array/table/cursor changes.
>
>No I do not do a requery for the dropdown list
>
>>HTH
>>Barbara