Attached is a portion of my file. At the top of the Pricing Sheet is a button called Add New Tire. When this is open I have highlighted the "textboxes" in yellow and the place where the calculated field goes in light blue. Open Add New Tire and in the yellow cells put any numbers (not big ones) but maybe something like 5, 5, & 5 These numbers per the calculation will equal 22. The problem I have here is that the calculated cell does not appear until I click on the Post Button and then the numbers you entered + the calculated cell will be posted to the Pricing Sheet. The calculated cell appears after you click on the Post Button, but I need to have that calculate cell visible before I post. If I see the results is way off, then maybe I have entered a wrong amount in one of the other 3 cells, so the purpose of this is so that if there is a wrong amount entered then it can be corrected before posting or it will have to be done manually corrected by going to the EOF to (My database has 4500+ rows). Go the VBA and the name of the form is AddTires and look at the code and let me know if you can fix it.
As usual, thanks for the great help i get my you'all and hope the moderator doesn't reject this one.
Jerry
Bookmarks