Transferring Userform Textbox Values to Access

[SINGERT]

Hello!
I'm relatively new to Access and have limited VBA programming skills. I have created a userform that lets people enter the different gauging values from various points on a part. There are also "click" buttons that they use to show if something "passed" or "failed" When I submit the userform, the "pass/fail" information transfers over just fine, but the numerical data entered into the Textboxes transfers as 0. I'm not sure what I'm doing wrong? Any thoughts?

 

[Micron]

Your methods are very unorthadox. Did you worry about declaring the public variables as Static or By Ref? If you set the value of a variable in such a way, it holds the value until something else changes or destroys it. Subsequent reference to it can return unexpected results that you may or may not notice. Also, this
Gearcase.Spec2_TextBox.Value
is not the way to refer to a form and any of its controls. Nor should you be using text if you want a number and then using the Val function to extract numerics from it. A minor point is that the default property of a textbox is .Value, so you don't need to refer to it. More importantly, Val(Gearcase.Spec2_TextBox.Value) will return 0 if it cannot find text that resembles a number, which is probably your major problem.