[AccessD] Requery ListBox doesn't work

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





More information about the AccessD mailing list