I am making a database that has a table consisting of 3 columns: problems, corresponding solution, and the amount of time that problem/solution has been selected. I made a form with a combo box that allows the user to select the problem and the corresponding solution is displayed. What I want to do is add a button that when clicked will increment the Usage field of the corresponding record that has been selected by the user. This will assist in tracking the most common problems being reported. I tried writing some VB for the On Click function of the button to increment Usage by one but cant seem to get it right.
Any help greatly appreciated.