decrement access table field value

[traceyae]

I need to decrement the 'stock' field value on receipt of a web order. I'm using access 2000. I've created an update query that will do this, but as far as I know, queries only work via forms. Can anyone offer any advice please?

 

[jacksonmacd]

Not really sure what you mean by "...queries work only via forms.." If you mean they can be used only as rowsources for forms, that's incorrect. You can execute an action query from a command button on your form. Put this in the Click event of a command button:

DoCmd.OpenQuery "Query1"