Hi to all,
I have a form with a listbox on it. When there are items ALREADY showing I
can double click on any item, open programmaticaly another form, edit the
item and close the form. On the close event of this second form I have a
listbox.requery command. As soon as the form closes my listbox updates
immediately. But not always! When there are no items ALREADY showing in the
listbox and I open the second form through a command buton (not with the
DoubleClick Even of the list box), add multiple items and then close the
form, the listbox is still showing empty. If I close the form containing the
listbox and reopen it or if I move to a different record and then return back
THEN the listbox is showing the newly added items and works as expected when
I edit them. Any clues how I can correct this behaviour?
thanks in advance, George
Graham Mandeno - 18 Aug 2005 10:35 GMT
Hi George
When you open the "edit item" form, you should open it in dialog mode, by
specifying the Windowmode argument as acDialog:
DoCmd.OpenForm "MyForm", ... WindowMode := acDialog
This causes the procedure containing this line to be suspended until the
form is either hidden or closed.
Then, after the DoCmd.OpenForm, add:
Me.[MyListbox].requery
This means the listbox will not be requeried untiol after the edit form is
closed.

Signature
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
> Hi to all,
>
[quoted text clipped - 15 lines]
>
> thanks in advance, George