Access2000 crashes on value asgn; Error: "Method 'Value' of object '_Textbox' failed"
I have this add data form. When I click on the add button it runs a series of DoCmd.RunSQL commands to make the additions.
It's developed in Access 2002 as a 2000 file. It runs fine on Access 2002, but on SOME Windows 2000 running Access 2000 machines, I encouter this error. I ran the debugger to find out where the error is occuring:
Me!txtSampleID = LocIDs(N)
LocIDs(100) is declared as Integer, and this line above is set in a loop.
The error I get is a Microsoft Access error: Method 'Value' of object '_Textbox' failed
I tried changing the line to
Me.txtSampleID.Value = LocIDs(N)
Now it crashes the entire program.
I've encoutered this error before in another subprocedure. I got around it by putting in some error trapping code, forcing it to run, and this worked. But doesn't work here.
I have this add data form. When I click on the add button it runs a series of DoCmd.RunSQL commands to make the additions.
It's developed in Access 2002 as a 2000 file. It runs fine on Access 2002, but on SOME Windows 2000 running Access 2000 machines, I encouter this error. I ran the debugger to find out where the error is occuring:
Me!txtSampleID = LocIDs(N)
LocIDs(100) is declared as Integer, and this line above is set in a loop.
The error I get is a Microsoft Access error: Method 'Value' of object '_Textbox' failed
I tried changing the line to
Me.txtSampleID.Value = LocIDs(N)
Now it crashes the entire program.
I've encoutered this error before in another subprocedure. I got around it by putting in some error trapping code, forcing it to run, and this worked. But doesn't work here.
