Barbara,

Hi, I posted this question a little bit ago, and I was wondering if I could get your opinion and see if you have any ideas that could help me to fix this.

TIA

Gil

Main problem: >>I have the strangest thing happening (again). I have set deleted ON in my form, and a grid which its data source is a view. On the lostfocus method I have code that deletes the current field if empty, so, when I press ENTER, it fires the code, deletes the record and takes it out of sight(set deleted working), but, when I use the arrow UP key, it fires the code, deletes the record but STILL I can see it on the grid (set deleted not working), inclusive, the delete mark shows to the left of the grid. What's going on? Why this type of behaviour on something so basic? I've used REFRESH and everything you can think of, but nada.




The strange thing is that since SET DELETED is ON, the record should not be visible in the first place, second, I tried what you suggested and still no success. But, hey, here's a snapshot of the screen and you'll see what I mean (to the rest of you guys, i also replied to you so get a visual idea of what's going on). Again, this will happen only when I press the arrow UP key to move from the grid to the form header; when I press ENTER there's no problem at all. I've spent too many hours and asked too many questions trying to fix this already, (and trying to get to Microsoft is not very easy).



Thanks for your help



Gil







>

>You are sitting on the record, and therefore you see it. You can actually GO 1234, and you'll see it, even if it's deleted. It's just that the commands which affect _tally will skip it (like running a report, Count, Sum, skip etc).

>

>The solution for your case could be

>

>delete

>locate rest

>if eof()

> go bott

>endif

>[fire any refresh now]

>

>This way you move off the deleted record, and the refresh will show the next available record, or the new last record (if you deleted the previously last one).

Dragan