How to Display List of Tables in a Combo Box

D

DevDaniel

I want a combo box to display a list of tables beginning with "src".

Any suggestions?
 
D

Douglas J. Steele

Set the RowSource to:

SELECT [Name] FROM MSysObjects WHERE [Name] Like "src*" ORDER BY [Name]
 
D

DevDaniel

Thanks, Doug! I appreciate all the help you have given me on these forums
over the past two years.

Douglas J. Steele said:
Set the RowSource to:

SELECT [Name] FROM MSysObjects WHERE [Name] Like "src*" ORDER BY [Name]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


DevDaniel said:
I want a combo box to display a list of tables beginning with "src".

Any suggestions?
Click to expand...
Click to expand...
 
Top