IIF Function and Comboboxes

[sps2]

The following shows me the results from a table with checkboxes that were checked or not. The ~ separates the different items, there are actually several other checkboxes not shown here. The user prefers to see text on report rather than checkboxes, so if check box wasn't checked then nothing displays. The last field [OtherText] is just that, text the user entered into that field and this displays fine.

=IIf([SuspiciousActivity]=True,"Suspicious Activity ~ ","") & IIf([Other]=True,"Other: ","") & [OtherText]

Problem is, in this one I am using a combo box to get the results for [InjuryTypeCombo], becuase we want to limit the data a user enters here. Anyway the field just displays the ID number of whatever the user selected. Now I know why it does that, I just don't know how to make the second column of text associated with that ID to show up here instead of the number.

=IIf([PhysicalAssault]=True,"Physical Assault ~ ","") & IIf([Injury]=True,"Injury: ","") & [InjuryTypeCombo]

Thanks for any help.

 

[vbaInet]

You haven't clearly explained your problem. What exactly are you trying to do?

Perhaps you could look into the DLookup() function in the meantime.