Listing DB Tables in a Listbox

[Richhol65]

Hi

I wonder could someone help.

I am after creating a list box that will display some of the tables within my database - there are between 10 and 15 tables and the names all follow the same pattern (They all start "tblD10")

It is probably something simple but I am not getting my head around it

Thanks

Rich

 

[Richhol65]

Hi I have solved this using the following QUERY as the source for the listbox

SELECT MSysObjects.Name AS table_name FROM MSysObjects WHERE (((Left([Name],6))= "tblD10")  order by MSysObjects.Name

Thanks

Rich