It sounds like you have executed that code twice, thus attempting to bind to the Text property of TextBox1 twice.
nope
there is Textbox1 and Textbox2
but I think I found the fault, it seems that Access 2000 can't handle it (only 2 Clients left with that antique)
it works with every other Access 2003 and up
SqLite etc....
to hunt a species to extinction is not logical !
since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.