How to call After update event to the textbox

[pwalter83]

Hi,

I have a added a code in the After Update event of a textbox which I need to call to display value in another textbox. This is what I have entered in the After Update event:
------------------------------------
Private Sub Text41_AfterUpdate()
[Me].[Text45] = DLookup("DIVISION_CD", "dbo_DIVISION", "[LINE_CD] = '" & [Me].[Text41] & "'")
End Sub
------------------------------------

Can some one pls tell what code or syntax I need to add in the text box control source to call the above After Update event ?

Thanks,
Paul

 

[vbaInet]

pwalter83,

This forum is constantly being moderated. Please do not double post:

http://www.access-programmers.co.uk/forums/showthread.php?t=219710