default value in text box

[Crash1hd]

Ok when I open a form from another form I use the following code

=[Forms]![QA_Index]![CCC]

to get the default vaule in a text box problem is that I have more then one choice of dropdown and I need that to change acordingly where if I choose ccc the its ccc if I choose IRO then it would be IRO sorta like this

=[Forms]![QA_Index]![CCC] Or [Forms]![QA_Index]![IRO]

But of course that doesnt work anythoughts?

 

[WayneRyan]

Crash,

Don't know what you're trying to say, but it sounds like you
need an Iif Statement.

IiF(IsNull(SomeField0, FieldA, FieldB)

Wayne