set value to record date and time

[rainbows]

this marco i found on an old database that records the date and time when the stockqty gets changed via the after update event
so i thought i could do the same think on a new database but i cannot find the "setvalue" from the dropdown box can you please advise what i am doing wrong

thanks steve

 

[Gasman]

You need to set for All Macro Actions.

 

[rainbows]

thank you , now working

steve

 

[Gasman]

thank you , now working

steve

Please mark as Solved then.

 

[rainbows]

this is how i have done it .is that correct?

 

[rainbows]

since checking what pat asked i have checked something and it is not quite doing what i would like it to do
when i type the qty into the stockqty field the datemodified works ok . but with my latest modification to the form it will not work

in the form below you can see a stock qty of 1260 if i change that manually the date /time will be recorded but having automated this function with an append query that stock will changes when i tick the "stock change" button but the datemodified dont. can i get it to do it both ways ?

steve

 

[rainbows]

I have removed the macro and did you you advised and changed the append query to include the datemodified and all seems to be ok
thank you will test again later today with real data not my test data