ReadioButton.Checked
Hi All,
I'm passing the parameter through Radio Button so the user can select the (Sale Person) from the List
During Testing wen I select specific Sales person (Mr B Smith) its show the results for the previous Sales Person (Mr A Smith)
I've two control on the form
SaleNameComboBox the data coming through from 'SalesPerson' query column of all distinct SalesName
SalesID ComboBox again the data coming through from 'SalesPerson' query column of all distinct SalesID
In the code window
I've use following codes
On the form Load
On the FilterRadioButton
On the btnOk_Click
hope make sense?
thanks for your help in advance
I'm passing the parameter through Radio Button so the user can select the (Sale Person) from the List
During Testing wen I select specific Sales person (Mr B Smith) its show the results for the previous Sales Person (Mr A Smith)
I've two control on the form
SaleNameComboBox the data coming through from 'SalesPerson' query column of all distinct SalesName
SalesID ComboBox again the data coming through from 'SalesPerson' query column of all distinct SalesID
In the code window
I've use following codes
On the form Load
Report.SetParameterValue("TechID", 0)
SalesTechNameComboBox.Visible = False
On the FilterRadioButton
If SalesTechNameRadioButton.Checked = True Then
SalesTechNameComboBox.Visible = True
'SalesTechNameRadioButton.Checked = True 'commented
'SalesTechNameComboBox.SelectedIndex = -1 'commented
'MsgBox("aaaa")
End IF
On the btnOk_Click
Dim i As Integer
Dim TechID As Integer
'Tech
If SalesTechNameRadioButton.Checked = True Then
i = SalesTechNameComboBox.SelectedIndex
TechID = SalesTechIDComboBox.Items.Item(i)
Report.SetParameterValue("TechID", TechID)
ElseIf TechNameRadioButton.Checked = True Then
Report.SetParameterValue("TechID", 0)
End If
hope make sense?
thanks for your help in advance
Comments
Kind regards,
Farhan