Use command button to enter data into field and save record

[phbryan]

Hello,



In the attached database I have a combo box for Pass/Fail and a command button to save and move to a new record. However, I'd like to combine the two functions and have two command buttons - one for pass and one for fail. When the user clicks either button, the command button should enter the correct value into the table and then save the record. I can't seem to figure out how to combine these two function though.

Any help would be great!Grinding Spot Check - Copy.zip

[Welshgasman]

I would just set the control bound to the field and create new record regardless. In doing so, the record would be saved. However, what happens when you do not want the new record?

[phbryan]

Most of the time I would want to save and move to a new record, but I was thinking of having the command button open up a Yes/No message box asking the user if they want to save the record. If yes save and new record, if no close message box and go back to the form.

[Welshgasman]

So what about when you want to save but not go to new record?, you have to stop data entry sometime.
I have entered over 20k records in a db using just 4 combos and tabbing to new record when needed. Data entry is then very quick, but easy to stop when finished. All controls are bound.