Listing Table Names in Combo Box

[Jeremy Shipley]

Can anyone tell me how to list a DB's Table Names in a combobox in access97?

[Douglas J. Steele]

Easiest way is to use the following SQL as the record source for the combo
box:

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

HTH

--

Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://I.Am/DougSteele/


Jeremy Shipley <jshipley@daytonparts.com> wrote in message
news:39170ed9$1@news.devx.com...
>
> Can anyone tell me how to list a DB's Table Names in a combobox in
access97?

[James Mahoney]

"Jeremy Shipley" <jshipley@daytonparts.com> wrote:
>
>Can anyone tell me how to list a DB's Table Names in a combobox in access97?

You could use the DAO tabledefs collection. For each table in an access
database there's a corresponding tabledef