See my answer to your post in excel.programming.

"Jennifer" wrote:

Hello guru's,
I have a listbox displayed in a form filled through the row source in
properties (a named offset). When the user adds data to a textbox then hits
the add button it goes to the database. The form remains open and i would
like to have the listbox update with the new information immediately instead
of showing the added data when i reactivate the form. Help.
--
Thank you,

Jennifer