[techthis]

hello...i have a program that get all of the tables in a db a lists them in a combobox...

is it possible to chose which tables are displayed in the combobox instead all of them???

if this helps, the tables i want displayed all have 2004 in the name , i.e. August2004, September2004, etc.

i thought i could do something like this

cmbTables.... = "*2004"

but this didn't worked...any ideas?....thanks for your time...

[Emily]

Well... you might have to re-structure your program to do it this way, but if you're using an ADO control, you can just change the record source in the code. (I think...)

What kind of data control are you using?

[techthis]

here is the connection im making...
Private Sub Form_Load()

con.Open "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=c:\test\test.mdb"

Set rs = con.OpenSchema(adSchemaTables)

Do While Not rs.EOF
cmbTables.AddItem rs("TABLE_NAME") 'ordinal index of 2
rs.MoveNext
Loop

End Sub

this retrieves all of the tables in the database...hope this helps...thanks for you time emily!