Unbound Combo Box on report (1 Viewer)

[Mr_Si]

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:

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

 

[Mr_Si]

Please ignore me, I've re-designed and done it properly