主题：权限

 我不想让库管组的人和李四打开时加载表A,下边这段代码错在哪？请老师指教 

Select Case e.DataTableName
    Case "表A"
        e.Cancel = (e.User.Group = "库管")
    Case "表A"
        e.Cancel = (e.User.Name = "李四")
    Case "表C"
        e.Cancel = (e.User.Name = "王五")
End Select

'参考
Select Case e.DataTableName
    Case "表A"
        If e.User.Name = "李四" Or e.User.Group = "库管"
            e.Cancel = True
        End If
    Case "表C"
        e.Cancel = (e.User.Name = "王五")
End Select


'或者这样

Select Case e.DataTableName
    Case "表A"
            e.Cancel = (e.User.Name = "李四") Or (e.User.Group = "库管")
    Case "表C"
        e.Cancel = (e.User.Name = "王五")
End Select

还真行，谢谢

嗯嗯

Select Case e.DataTableName
    Case "表A"
        e.Cancel = (e.User.Group = "库管")
        e.Cancel = (e.User.Name = "李四")
    Case "表C"
        e.Cancel = (e.User.Name = "王五")
End Select

 

这样也行吧

五楼说的，李四还能加载，我试了，不过，也一并表示感谢

 

怎么可能还会加载呢？