ControlSource problem

[akhmadahdiyat]

why I can't set control source for control ?

    varUserID = "=IIf(IsError([UserCariSubForm].[Form]![Login]);'';[UserCariSubForm].[Form]![Login])"
    Msgbox varUserID              'the message result exactly the same in expression box.
    TextUserID.ControlSource = varUserID

[amrut]

does this works ?

 varUserID = "=IIf(IsError([UserCariSubForm].[Form]![Login]),' ',[UserCariSubForm].[Form]![Login])"
    Msgbox varUserID              'the message result exactly the same in expression box.
    TextUserID.ControlSource = varUserID

[akhmadahdiyat]

replace ; with ,
it works,, thanks.. i wonder why..

[amrut]

It is the syntax for IIF statement

IIF(Condition,If true this,If false this)