IIf statement

[awake2424]

This seems correct, but it is not working.

=IIf([Results]="Negative","No Variants Detected")

Thank you.

 

[pbaldy]

Try

=IIf([Results]="Negative","No Variants Detected", "")

If not, verify what the Results field actually contains. "is not working" is pretty vague.

 

[awake2424]

 =IIf([Results]="Negative","No Variants Detected","")

Eventhough the Results field Combobox is Negative the text does not fill in the textbox. Thanks.

 

[pbaldy]

Are you sure the combo's bound column isn't an ID field or something? Can you post the db here?

 

[missinglinq]

To test that possibility, place this code in the Form's code module, then make a selection from the Combobox and see what value shows in the Messagebox:

Private Sub Results_AfterUpdate()
 MsgBox Me.Results
End Sub

Linq ;0)>