帮看下为什么窗口模板不能动态更新

号子

如题,更新Cb01的值后提示属性2101错误,不知道错在哪,谢谢,

aslxt

Cbo1的RowSource属性修改为：
SELECT IIf([type]=1,"表." & [Name],"查询." & [Name]) AS 表达式1, MSysObjects.Type FROM MSysObjects WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=5));

号子

SELECT IIf([type]=1,"表." & [Name],"查询." & [Name]) AS 表达式1, Left([MSysObjects].[Name],4) AS 表达式2 FROM MSysObjects WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=5) AND ((Left([MSysObjects].[Name],4))<>"MSys"));
呵呵,谢谢了,我又加了个条件