Hi folks! I have this silly thing i cant get to work.
"I have this combobox with values stored in a table, for each record it represents the status of the order, and each value has a background color."
This seems to work just fine with just 1 single IF statement...but when i add another, its just a white background (nothing happend)
Can someone explain to me whats happening and how i can add multiple IF statements here?
Private Sub Form_Current()
DoCmd.ShowToolbar "Ribbon", acToolbarYes
If orderstatuscombo.Value = "Order created" Then
orderstatuscombo.BackColor = 3881966
If orderstatuscombo.Value = "Pre-configuration" Then
orderstatuscombo.BackColor = 1219071
Else
orderstatuscombo.BackColor = 16776960
End If
End Sub
Also, what should this combobox do in the property sheet? What kind of event is it.
Im so lost now with trying anything...please help!