Buttons to add, substract and reset values

[squashedmos]

Greetings. I'm rather new to access and VB so I'm having a bit of trouble here. I need a button that on click permanently adds +1 to a specific number field on the form's table, one that permanently subtracts 1 to that same number field and one that resets the value of ALL number fields from all registries on the table to 0. What code do I need to implement to get those things done? I've been searching and read several similar situations but what options I've tried have not worked at all :S.

My number fields are Prof 1, Prof 2, Prof 3.



Thanx in advance.

[June7]

Don't understand.

What are registries?

You want a table full of zeros? The same table just added and subtracted to?

Could you explain more what you are doing and why?

Do you want to provide the project for analysis?

[squashedmos]

Greetings and thank you for your answer.

My structure is as follows

Customer Prof1 Prof2 Prof3
Stud1_____1________5
Stud2_________2___6
.
.
.

The purpose of this DB is to keep record of how many classes each professor has given so here Prof1 gave 3 in all. By registry I mean each student, so the registry for Stud2 has clases on both Prof1 and Prof2. What I need are two buttons that I can put in the form next to Prof1, Prof2 Prof3, one to +1 and the other to -1 the number of clases said professor has given, say, Stud1 so that each time Stud1 shows up I just +1 the corresponding professor.

As to the button to reset all Prof1-2-3 values to 0 I solved it with an update query, since this option will be used once a month to whipe the record clean, it's not such big a deal clicking on the "yes I am sure I want to erase" thing, but it would be maddening to have to go over that every single time I need to +1 a Professor :S. I hope I have made myself clear n_n'

[June7]

I use only VBA code. So in button Click event select [Event Procedure]. Double click the ellipses (...) and that will but you in the procedure in the VBA editor. Type code like:

Me!Prof1 = Me!Prof1 - 1

Adjust the sample expression for each button you create. The code will act on the record that has focus on the form.

[squashedmos]

@_@ Thanks a lot, worked like a charm!