Jim Hewson
JHewson at karta.com
Mon Jul 12 08:05:25 CDT 2004
Sorry, left for the weekend before I received any replies. Thanks for your replies. I'll answer each now. Chris - requery is called from the after update event of the text box. Doesn't work. I've tried repaint and refresh - still doesn't work. John - the event property of the control is filled in, checked it numerous times - even made sure the name of the controls were different than field names. Rocky - set a breakpoint it stops correctly, set a breakpoint on the line after - it stops correctly. I've tried using a querydef as the row source and a SQL statement. Doesn't make a difference. I also added a line to setfocus on the control, then requery and then setfocus on another control. The focus changes as expected and moves to the control after the requery line... still doesn't requery. Any other suggestions? Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of bchacc at san.rr.com Sent: Saturday, July 10, 2004 8:51 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Requery ListBox doesn't work Jim: Didi you set a breakpoint on the second one to see if the code is actually being executed? Rocky Original Message: ----------------- From: Jim Hewson JHewson at karta.com Date: Fri, 09 Jul 2004 15:00:14 -0500 To: accessD at databaseadvisors.com 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 -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ . -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com