Moving a value from a variable to a table

[SteveC24]

Hello,

I have some code with puts the value in a field in a table into a variable ("T"). I then add 1 to the value, then I want to put the number in the variable back into the table.

The result should be that the value in the table has increased by one.

How do I take it from the variable and put it back into the table?

Thanks!

 

[a.sinatra]

Update query?
________
Sex video

 

[SteveC24]

from within VBA?

There must be a simpler way?

 

[SteveC24]

Thanks Pat, with a bit of fiddling, that did it a treat!