Hi all,
I have an unbound combo box on a report that looks up to a table of address data.
I have a specific requirement where if one of the bound fields on the report is a specific value, I want the combo box to show data. If the bound control on the report is a different value, I want the data in the combo box to be different.
I have tried using the OnOpen method, but it says I cannot assign a value to it.
I have tried using the OnLoad procedure, but it doesn't show anything.
the code is as follows:
Does anyone have any ideas?
Thanks,
Simon
I have an unbound combo box on a report that looks up to a table of address data.
I have a specific requirement where if one of the bound fields on the report is a specific value, I want the combo box to show data. If the bound control on the report is a different value, I want the data in the combo box to be different.
I have tried using the OnOpen method, but it says I cannot assign a value to it.
I have tried using the OnLoad procedure, but it doesn't show anything.
the code is as follows:
Code:
Private Sub Report_Load(Cancel As Integer)
If Me.[Dispatch Type] = "Sent to A" Then
Me.cboDispatchTo = 15
ElseIf Me.[Dispatch Type] = "Sent to B" Then
Me.cboDispatchTo = 8
End If
End Sub
Does anyone have any ideas?
Thanks,
Simon