To be honest I find it hard to follow your scenario...but I suspect part of your problem is here
Text44.Text
You can only refer to the Text Property when the Text44 Control has the Focus! Otherwise you need to use Text44.Value in referring to it.
Since Value is the Default Property of Textboxes...you can simply use
Text44
as
ranman256 did in his code
=mid(text44,Instr(text44,"(")+1)
Also, since Access (unless you explicitly diddle with it) is Case Insensitive, you don't need to use UCase.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007