Show List of Tables

[Gulf Coast Electric]

I need to use a form to show a drop down list of the tables in my database.
What is the syntax for the query Please.

Thanks,


Dave

 

[Allen Browne]

SELECT MSysObjects.Name FROM MSysObjects
WHERE Type = 1 AND Not (Name Like "MSys*" Or Name Like "~*")
ORDER BY MSysObjects.Name;