Chris Kettenbach
chris at piasd.org
Fri Jul 9 16:14:19 CDT 2004
What event are you calling the requery method from? Try the afterupdate event of the text box. Also maybe repaint or refresh the form. Hope this helps. Chris -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson Sent: Friday, July 09, 2004 1:00 PM To: AccessD Subject: [AccessD] Requery ListBox doesn't work Two identical lines of code to requery a ListBox, one works, one doesn't. Both on the same form, both reference the same ListBox. The one that works is located on the on click event of a button to delete the current record. Delete the record - requery the ListBox. Works. The one that doesn't work is on the after update event of a text box. Enter text - move to next text box - requery ListBox. Doesn't work. A2K - I also imported everything into a new database container. still didn't work. Any idea why? Thanks in advance, Jim