Jim Hewson
JHewson at karta.com
Mon Jul 12 08:48:52 CDT 2004
Thanks for the suggestion. Tried it - still doesn't work. However, it does requery and displace the previous change! I've used the requery on several forms and it usually works. I just cannot figure out why on this form it doesn't! Thanks Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock Sent: Monday, July 12, 2004 8:10 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Requery ListBox doesn't work Hi Jim I guess you need to save the record before asking for the requery. /gustav > 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. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com