Textbox AfterUpdate Issue 1

[xweyer]

I have a form with a text box aka txtOrgCode with code in the AfterUpdate event that check the user's entry against a set of rules. That code works as intended.

As an alternative to directly entering data in txtOrgCode I also have another pair of text boxes which allow the user to enter a value to search for in an external database (txtSrchOrg) and if a match is found display the results in a third textbox (txtFndOrg). This all works fine too.

The problem I'm having is with the last step of the above which would be to transfer (via a command button) the contents of txtFndOrg to txtOrgCode. The command button for this works fine (just executes a simple Me.txtOrgCode = Me.TxtFndCode) but the problem is that when the data moves this way the afterupdate event of txtOrgCode never gets triggered and the code behind that textbox never runs.

Since I still need to check the that value is valid I'm wondering if there is some means of forcing that event to fire?

 

[bubba100]

try adding to the command button Call txtOrgCode_AfterUpdate.

 

[xweyer]

Thanks Bubba,

That worked perfectly.