Where's my new table

[DZ]

Greetings

New tables I create dont show up in listboxes that display
table names. How can I make new table name appear
immediately without closing the reopening the database.

I tried using:

Application.RefreshDatabaseWindow

That did not make the tables appear, even if I closed and
reopened the listbox. The only thing that works for me is
to close and reopen the database.


Windows 2000, Access 97

DZ

 

[Wayne Morgan]

Try requerying the listbox.

Example:
Me.lstMyListbox.Requery

 

[DZ]

Thanks Wayne for the response.

My problem remains. Requerying the list box doesn't work,
nor does Application.RefreshDatabaseWindow, nor does
closing and reopening the form.

The only thing that makes a new tables appear in the list
box is closing and reopening the database.

Note: I'm filling the list box by using the UserDefined
function as the RowSourceType, because there are hundreds
of tables. I experimented and this problem does not occur
if I use DAO to fill the list box. I can't use dao because
of the number of tables.

Any other suggestions would be appreciated.

 

[Wayne Morgan]

What happens if you reassign (change) the RowSource type? Does this make the listbox run
the function again? You may need to change it to something different then back again. If
this causes a flashing problem, set the screen echo to false while you do this.