using queries to delete

[scratch]

I hopefully will solve a major problem by deleting with a stored query. Right now a user selects records from a listbox and then deletes if need be. Here's my present code

    DoCmd.SetWarnings False
    DoCmd.OpenQuery "Query5"
   
    Me.lstClinic.Requery
     DoCmd.SetWarnings True

The delete works fine but when a user clicks on the listbox to select another record after the delete they get a message that says :

The data has been changed
Another user edited this record and saved the changes before you attempted to save your changes.
Re-edit the record.

This despite this being run off the desktop with no chance of another user to do anything. I guess it needs to be refreshed but .Requery doesn't work. Any suggestions?

scratch

 

[ghudson]

I think that you also need to requery the forms record source.

 

[modest]

Put in a
Me.Refresh