Give info if one textbox if other textbox have certain info

[hendrikbez]

Is this possible, I have 5 textboxes in my form, in my fist textbox I am putting info in, so I want my last Textbox to give certain info if there is something in the first text box.

Eg. in my first Textbox I have AAG123, so in my last textbox I want this to have this info "UNIX" in last textbox.

There is a few different info that can be shown in last textbox, and different tape numbers. will have diffrent info

Is there a sample or how do I get this to work

 

[llkhoutx]

Use the "iif" function to store the value you want.https://support.office.com/en-US/Article/IIf-Function-32436ecf-c629-48a3-9900-647539c764e3?ui=en-US&rs=en-US&ad=US

 

[pr2-eugin]

Without much info, suggestion is very limited. What could be the possible combinations? Would Cascading ComboBoxes suit you?

 

[hendrikbez]

Use the "iif" function to store the value you want.https://support.office.com/en-US/Ar...8a3-9900-647539c764e3?ui=en-US&rs=en-US&ad=US

Thank for the info.
I have try to do this

Private Sub cmdSystem_Click()
DisplayText: IIf(Eval([Tapes] In ("AAG*","NSW*","NJQ*")),"UNIX"," ")
End Sub

but is getting compile error, "Expectewd:list seperator or" at IN
I am not so good with vba at the moment