Show List of Tables

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

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
 
SELECT MSysObjects.Name FROM MSysObjects
WHERE Type = 1 AND Not (Name Like "MSys*" Or Name Like "~*")
ORDER BY MSysObjects.Name;
 
Back
Top