narrowing list of MsysObjects displayed

[CJ]

I have a combo box that currently lists all tables in my
database so that they may be "selected" from. I would
like to restrict the list of tables to only those with a
particular naming scheme. (e.g.: list all tables with
names ending in the letters "ing".

Thanks in advance for your help.
CJ

 

[Graham R Seach]

CJ,

SELECT [Name]
FROM MSysObjects
WHERE [Type] = -32768 AND [Name] LIKE "*ing"

....or...

SELECT [Name]
FROM MSysObjects
WHERE [Type] = -32768 AND Right([Name], 3) = "ing"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia