Jim Hewson
JHewson at karta.com
Mon Jul 12 12:14:34 CDT 2004
Thanks, Gustav! It works. On a whim, I decided to try refresh one more time. It worked! Thanks everyone for your help. 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 9:04 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Requery ListBox doesn't work Hi Jim Then you probably need to requery the form after having saved the record ... /gustav > 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