Update Query from Form

[ste_pie87]

Hi

Please find attached the db for help understanding the problem

I have a box in the form frm_Sound which is "Overall_Change". This will always be a number either positive, zero or negative. What I require is for that number to be added to a new table "Value" in the field "Number"



So, Once a submit button is clicked for example, that number will be added as a new record to the table "Value" in the "Number" field and in the "Type" field, it will say whether it is positive, negative or zero.

So, what I require is some code that takes the number, recognises that it is either positive, negative or zero and updates it into a table. I think I need some sort of update query, right?

Can anyone help with this please? I just can't seem to work out the way to do this.

Thanks

[ste_pie87]

Can anyone help with this please, i'm really struggling.

[RuralGuy]

How about starting by not using any reserved words as names for objects? It does not look like you have event started on a Submit Button. You need to base your form on a query with calculations in it and not a table directly.