在form1的command1中调用form2(load form2),并向它传递一个参数到form2.tag中(字符串),可是我现在想在form2的form_load事件里,判断form2.tag的值。但这样做可能行不通,大家能给我一下帮助吗,谢谢
command1_click()
form2.tag="YEIAD"
load form2
end subfrom2
from_load()
if me.tag="YEIAD" then
rs.open"....."
else
rs.open"...."
end if
end
command1_click()
form2.tag="YEIAD"
load form2
end subfrom2
from_load()
if me.tag="YEIAD" then
rs.open"....."
else
rs.open"...."
end if
end
form1
command1_Click
form2.tag = "YELAD"
form2.show
end subform2
form2_load()
if tag = "YELAD"
rs.open ""
else
rs.open ""
end if
end sub
Form2_Tab = "a"
Form2.Show
End SubPrivate Sub Form_Load()
Me.Tag = Form2_Tab
If Me.Tag = "a" Then MsgBox ("dsf")
End Sub
你可以在公共模块中申明如下:
Public mTab As String '定义全局变量Private Sub Command1_Click()
mTab = "YEIAD"
Form2.Show
End SubPrivate Sub Form_Load()
Me.Tag = mTab
If Me.Tag = "YEIAD" Then
MsgBox ("YEIAD")
End if
End Sub
mTab = "YEIAD"
Form2.Show
End SubPrivate Sub Form_Load()
Me.Tag = mTab
If Me.Tag = "YEIAD" Then
MsgBox ("YEIAD")
End if
End Sub