I have a listbox that gets its data by querying a table.
The user is able to double-click on an item in the list
and have a popup form appear which allows the user to edit
the item in the list. The listbox needs to requery the
table rather often, so that as the user modifies the
table, the changes will be immediately reflected in the
I have attempted to accomplish this by setting the form's
OnTimer event to requery the listbox every 1000ms. To
avoid getting an Error 2118, I have the OnTimer event save
the record before requerying the listbox. However, this
has adverse effects, such as causing the cursor to act
funny while editting fields in the popup form, and
eliminating the possibility of having a cancel button on
the popup form, as the record is being saved constantly.
1) Somehow pause the form with the listbox while the popup
form is open, and/or