呼叫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??