ReadioButton.Checked

Farhan

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

wrote:

Report.SetParameterValue("TechID", 0)
SalesTechNameComboBox.Visible = False

On the FilterRadioButton

wrote:

If SalesTechNameRadioButton.Checked = True Then
SalesTechNameComboBox.Visible = True
'SalesTechNameRadioButton.Checked = True 'commented
'SalesTechNameComboBox.SelectedIndex = -1 'commented
'MsgBox("aaaa")
End IF

On the btnOk_Click

wrote:

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

Farhan

I've found the problem the reason why there are some duplicated Sales Names
Kind regards,
Farhan