Bill Benson (vbacreations)
vbacreations at gmail.com
Mon Jun 14 11:12:12 CDT 2010
Yes that would work. I want the recordsource updated when something is added to the listbox also, of course. But right, I would just have both routines - the one adding an item and the one removing an item - call the routine which updates the recordsource. Ah, the difference between midnight and 10AM is like night and day. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Monday, June 14, 2010 11:07 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] AfterUpdate eclipsing DblClick? I may be missing something here, but if you are running code in the double click event that deletes data in the row source table, then why not just run your 'refresh the form' code in the same Double-Click event handler, after the deleting has happened? Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson (vbacreations) Sent: Monday, June 14, 2010 10:29 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] AfterUpdate eclipsing DblClick? Hi, I have an unbound listbox. The items in the listbox are stored in a table (the control's rowsource). When I double click an item in the listbox, the item is deleted from the rowsource. So far so good. I would like that whenever the contents of the rowsource changes, the form will requrey itself. (Actually, I want the listbox's rowsource to be instrumental in how the form is itself filtered, but saying it simply as "form is requeried" sets up the same scenario, just more simply. Problem: Clicking on an item in the listbox triggers its afterupdate event. That event preempts the listbox doubleclick event. So I can't use the afterupdate event. There is no "contents-have-changed" event for a listbox or its rowsource, is there? So I can't think when to do the recordsource adjustment. Is there another way to finesse this? -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.829 / Virus Database: 271.1.1/2937 - Release Date: 06/14/10 02:35:00