[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