"Argument not optional" when using Iif

[gdonald20]

Hi

I have an after update event on a field on my people form.


When i try to debug the code i get an "Argument not optional" error in
relation to the IIf statement.


I used the same code in an update query and it worked perfectly.


PE_Initials = (Left([PE_First_Name], 1) & IIf(InStr(1, [PE_First_Name],
" ") <> 0, Mid([PE_First_Name], InStr(1, [PE_First_Name], " "), 2)))


Can anyone tell me why this doesn't work in the code module.


Thanks


Gillian