Requery after listbox delete causing error

[David]

My listbox allows deletions. After I process a delete, the
code does a requery to refresh the listbox. The requery
statement causes an error "you must save the current field
before you run the requery action". What does this mean
and how do I fix it?
When the delete key is pressed, I do have to loop thru the
list box entries to validate the deletion.

 

[Allan Bach]

Sounds like you may be using the BeforeUpdate event. Try the AfterUpdate event.

 

[David]

This is in an On KeyDown event to trap the delete key.