Unbound Combo Box on report (1 Viewer)

Mr_Si

Registered User.
Local time
Today, 05:49
Joined
Dec 8, 2007
Messages
163
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:

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
 

Mr_Si

Registered User.
Local time
Today, 05:49
Joined
Dec 8, 2007
Messages
163
Please ignore me, I've re-designed and done it properly :)
 

Users who are viewing this thread

Top Bottom