表A副本为当前表时,按钮1可用
表B副本为当前表时,按钮2可用
表C副本为当前表时,按钮3可用
下面的代码为什么都不行,应该如何写?
一、
If e.Sender.Name = "table1" Then
e.Form.Controls("Button1").Enabled = True
e.Form.Controls("Button2").Enabled = False
e.Form.Controls("Button3").Enabled = False
ElseIf e.Sender.Name = "table2" Then
e.Form.Controls("Button1").Enabled = False
e.Form.Controls("Button2").Enabled = True
e.Form.Controls("Button3").Enabled = False
ElseIf e.Sender.Name = "table3" Then
e.Form.Controls("Button1").Enabled = False
e.Form.Controls("Button2").Enabled = False
e.Form.Controls("Button3").Enabled = True
End If
二、
If CurrentTable.Name = "table1" Then
e.Form.Controls("Button1").Enabled = True
e.Form.Controls("Button2").Enabled = False
e.Form.Controls("Button3").Enabled = False
ElseIf CurrentTable.Name = "table2" Then
e.Form.Controls("Button1").Enabled = False
e.Form.Controls("Button2").Enabled = True
e.Form.Controls("Button3").Enabled = False
ElseIf CurrentTable.Name = "table3" Then
e.Form.Controls("Button1").Enabled = False
e.Form.Controls("Button2").Enabled = False
e.Form.Controls("Button3").Enabled = True
End If
三、
If e.Sender.Name = "公司_table1" Then
e.Form.Controls("Button1").Enabled = True
e.Form.Controls("Button2").Enabled = False
e.Form.Controls("Button3").Enabled = False
ElseIf e.Sender.Name = "公司_table2" Then
e.Form.Controls("Button1").Enabled = False
e.Form.Controls("Button2").Enabled = True
e.Form.Controls("Button3").Enabled = False
ElseIf e.Sender.Name = "公司_table3" Then
e.Form.Controls("Button1").Enabled = False
e.Form.Controls("Button2").Enabled = False
e.Form.Controls("Button3").Enabled = True
End If