Prefix Text box based on combobox selection

[whitelockben]

SOLVED: Prefix Text box based on combobox selection

Hi all,

I want to add a prefix to a text box based upon a selection from a combobox.

Specifically,

if cboSeg = C&I txtCN prefixed 'C'
if anything else prefixd 'P' and if nothing, no prefix.

Can someone help me with this please.

Thanks,

Ben.

 

[vbaInet]

Have a look into the IIF() function:

http://www.techonthenet.com/access/functions/advanced/iif.php

 

[Mr. B]

Try the following code in the "After Update" event of your combo box:

If Not IsNull(Me.cboSeg) Then
     If Me.cboSeg = "C&I" Then
          Me.txtCN = "C"
     Else
          Me.txtCN = "P"
     End If
Else
     Me.txtCN = ""
End IF