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.

Using Requery in the AfterUpdate event should do it. You sure the code's actually firing (and that you're doing the requery on the correct control)?

Got it, thanks a lot for your help and keeping me on track.

In each of the appropriate controls' after update events, I had to do this and it worked perfectly:


Thanks again.