command buttun to subtract 1 from a field value

[thomingo]

S0S.... I nid help on a visual basic If statement in ms access.. I got a form with a field called [copies on hand] so i made a command button and when i click the button, i want the value in the field [copies on hand] to be subtracted by one.....
The code i hev thats not workin is

Private Sub Command 25_Click()
If [copies_on_hand] >0 Then [copies_on_hand] = ([copies_on_hand]-1)


End Sub

[pbaldy]

Code looks okay. What is happening? I would drop the parentheses, which might be returning a Boolean.

[thomingo]

nothing is happenin when i click the button..

[pbaldy]

Is any code running? The db has to be in a trusted location or you have to explicitly enable code.

[thomingo]

maybe thats the problem. How do i enable code? Im using access 2007

[pbaldy]

Is there a link to click on under the ribbon?

[thomingo]

yes yes its writen: security warning certain content in the database has been disabled

[pbaldy]

You have to click on that to enable code to run.

[thomingo]

it worked!! Thank u very much boss!! Yaaay

[pbaldy]

Happy to help and welcome to the site!