List Tables in a List Box

Make this the Row Source of the List Box:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=1))
ORDER BY MSysObjects.Name;

mx

Hi Buck_Beasom

try this
http://www.programmersheaven.com/mb/access/394600/394660/re-creating-list-box-of-tables-within-database/?S=B20000
http://office.microsoft.com/en-us/access-help/create-a-list-box-combo-box-or-drop-down-list-box-HP005240581.aspx
http://office.microsoft.com/en-ca/access-help/specify-which-row-is-the-default-value-in-a-list-box-or-combo-box-HP005188669.aspx

Good luck & hopefully can help u ^^

<*No Points wanted*>
You can revise the SQL MX posted to exclude system tables with something like this:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type=1 AND Left(MSysObjects.Name,4)<>"msys"
ORDER BY MSysObjects.Name;

Both your solutions were helpful!