Dim obj As AccessObject, dbs As Object
Dim strList As String
Set dbs = Application.CurrentData '建立数据库对象记录集
strList = ""
For Each obj In dbs.AllTables '遍历数据库中的所有表
If Left(obj.Name, 4) <> "Msys" Then '剔除系统数据表
strList = strList & obj.Name & ";" '合成导入的表名组合框的行来源中的数据
End If
Next obj
Me!导入的表名.RowSource = strList '赋值给组合框