返回首页

呼叫1 Funtion /程序:

I have 3 ComboBox, 1 TextBox controls in my "Generate Report" Form,

 

ComboBox1 = "Regions"

ComboBox2 = "Area"

Combobox3 = "Branch"

TextBox1  = "Date"

 

Any Values selected/displayed from the 3 ComboBoxes, becomes a function/procedure.. 

 

Dim registrant, spName as String

 

ComboBox1 = "Region IV"

ComboBox2 = "Cavite"

ComboBox3 = "Bacoor"

TextBox1  = "10/25/2011"

 

registrant = ComboBox1.SelectedItem & '' & ComboBox2.SelectedItem & '' & ComboBox3.SelectedItem



Registrant will then become this "REG_IVCaviteBacoor"

 



and my code will look like this,

 

spName = "CALL " & Registrant & "()"

 

spName = CALL REG_IVCaviteBacoor()

 

How can i call that Function??

 



回答

评论会员: 时间:2