Hi all, I have an issue with my form for my "nettweight" and "loss" textbox which keep showing #type! on my textbox after i click on "Clear" on my textbox. I realize that it is because i use these two textbox control source for calculation. Hence, once i removed the calculation in the control source, the #type! on my textbox was gone.
I would like to know how to write code so that when the form load together with all the data or when user click on 'next" for the next record set, it will automatically show the nettweight.
Formula: pounds/2.2
Next, i would like the code to work in the same way for the loss as well, when user key in the grossweight the loss will automatically be calculated and show in the loss textbox.
I have also attached my database above.
Thankyou! Have a good day