Private Sub Form_Open(Cancel As Integer)
If CurrentPopedom = "管理员" Or CurrentPopedom = "部门经理" Or CurrentPopedom = "公司领导" Then
Me.RecordSource = "派单查询"
Else
Me.RecordSource = "营销派单查询"
End If
Me.Requery
End Sub
现修改为:
Private Sub Form_Open(Cancel As Integer)
If UserID = "0000---0030" Then
Me.RecordSource = "派单查询"
Else
Me.RecordSource = "营销派单查询"
End If
Me.Requery
End Sub
请教高手们:
1、这句应如何改:If UserID = "0000---0030" Then
2、这个命令应改为什么:RecordSource 作者: 咱家是猫 时间: 2010-7-20 12:05
Private Sub Form_Open(Cancel As Integer)
Select case UserID
case "0000","0010","0030"
Me.RecordSource = "派单查询"
case Else
Me.RecordSource = "营销派单查询"
End select
Me.Requery
End Sub