So I wanted to piggyback a question on the original question. I used the code given above to add fields from a form into a table upon a user click on a button. After doing that, how can I take those values and add them together as well as go to a new record upon clicking this button.
Here...
Thanks for the link. My problem is that I am a complete newbie to Access and I have no idea what to do with all that code. I was hoping that there was just a way to add a line of code so that it only adds the fields to the table after hitting the control button. I am guessing that it isn't...
Adding on to this question....
So is it possible to have a form that only updates the table it is bound to after a command button is clicked? So I enter a bunch of data into a form and hit an "update button" and that data is entered into the form. But if enter all that data into the form and...