I can't seem to get this list box to update itself when I add, or edit, or "delete" a record. (I wrote delete as "delete" because I'm not really deleting the records. I have a Delete button that writes the date into the record, and when that field has a value in it, the query doesn't return that record, so it's like the record is deleted, but it's recoverable if I wanted to.
Anyway, I can't get my list box to refresh itself when I do any of these three things. I'm using the me.listboxname.requery command. I've tried it in the Form's current, after update, and dirty events. Nothing happens. How can I do this? Thank you.