mid is an intrinsic fucntion of VB/VBA - if it isn't present on your XP computer, then I'd suspect that a library or reference is missing. To fix this open a form in design mode
view the code.
from the code window select tools references and make sure that visual basic for applications is ticked.
I'd scan through the list of references to see if any are missing
VB is still used even in a query. I even have queries that call VB functions which is rather neat. A query is just a visual representation of an SQL statement. anyway he is right - you need to check your references and see what you are missing. It is possible the syntax needs to be checked- I had some 97 queries that needed updating in the string manipulation as Office 2003 and XP were more picky than the old 97 and WNT I had been using.