Formula #Error?

[harpscardiff]

Hi,

can anybody spot what is wrong?
System name is a drop down list, with different options
Text125 changes based on the dropdown.
Entered in the text125 control source

=IIf([tblSystemName_System Name]=Null,"",IIf([tblSystemName_System Name]="AS400",[text125]="AS400 Profile",IIf([tblSystemName_System Name]="Credit Apps",[text125]="Credit Apps","Misc")))

Thanks

 

[RuralGuy]

You should use the AfterUpdate event of your ComboBox to populate the text125 TextBox with code like:

Private Sub [b]YourComboBoxname[/b]_AfterUpdate()

Select Case Me.[b]YourComboBoxname[/b]

   Case "AS400"
      Me.text125 = "AS400 Profile"
   Case "Credit Apps"
      Me.text125 = "Credit Apps"
   Case Else
      Me.text125 = "Misc"
End Select

End Sub

Replacing YourComboBoxname with the actual name of your ComboBox control of course.