[AccessD] Keeping place after requerying

Hi Selina

> When I delete a record it puts #DELETED# across all the fields.  I requery
> it so that they don't see this.

That means that the record is deleted from the recordset and not by
the form.

If Bruce's method works go for it - you may wish to wrap it in
Painting = False and Painting = True to prevent some flickering.

/gustav

>> > I understandably annoyed customer because everytime they delete
>> > something
>> > from their very long list and the data is requeried (via code), they end
>> > up at the top of their list again and have to scroll down.
>> > Can anyone please help in how I keep the focus on the next record to the
>> > one they have just deleted?
>>
>> Why do you requery the form? That shouldn't be necessary - except for
>> an unbound form ...