Have a listbox bound to a "work" table this is refreshed with a delete query and then an append query.
Because it takes a long time I am seeing the listbox rows show #deleted# for a second or two before the new values come up.
Is there a way to suppress this?
Was thinking to first to the delete query and then requery the listbox so it shows empty. Then to do the append query and requery the listbox again.
Or else would it make sense to do nothing until the table is rebuild and then reset the listbox recordsource?