Using the IIF statement?

[Terryb07]

Hello
I have a form and a blank unbound field. I would like to create a formula that says if a Dept in the Staff field Table is the same as the Dept in the Manager field table, then that is OK otherwise allocate new manager. I keep getting an wrror message when I rey and amke it work. Any ideas?

[CJ_London]

Any ideas?

not without knowing what code are you using at the moment - and what is your error message?

[Micron]

Hello
otherwise allocate new manager. I keep getting an wrror message when I rey and amke it work. Any ideas?

Also, what do you mean allocate a new manager? You cannot use the IIF function to direct a user to supply an alternate choice of anything. Basically, you can only say "If condition A, then condition B, otherwise condition C." and make something equal the result. If these abstract values you refer to are table/field references then I suggest the following (if not, replace those references with your values).

something = IIF([tblStaff].[Dept] = [tblManager].[Dept] then [tblStaff].[Dept],"theOtherValue")
I presume you could use either the Staff or Manager value for the red part since if it passes the first test (returns True) it should not matter which you use as they are equal.
"Staff field Table" - I'm guessing Staff is a table, but your wording is confusing.

If you do not have a specific value (alternate) to pass to the function in the case A and B are not equal, I do not see how you can use the IIf function for this.