OnGotFocus event

[Royce]

I am trying to set event handlers on multiple controls in code.
This works:

Me.Controls("txtPosition" & Right(CStr(iLoop + 100), 2)).OnClick = "=UpdateTaskList(" & CStr(iLoop) & ")"

This doesn't:

Me.Controls("txtPostIt" & Right(CStr(iLoop + 100), 2)).OnGotFocus = "=PostItGotFocusHandler2()"

The second gives an error: "The expression you entered has a function that <databasename> can't find.

I suspect it may be a parameter mismatch, but the normal GotFocus event handler does not take any parameters.

What do I need to do.

 

[ChrisO]

Is PostItGotFocusHandler2() a Function or a Sub?

Chris.

 

[Royce]

I'm brain dead. It's was a sub. Changed it to a function and all is well. thanks!