before change macro if record status="n" (1 Viewer)

[murray83]

morning all have the following attached macro but cant seem to get it to work as i would like

if i don't add in the If then it works fine and after every update it adds the Now() time to endtime filed even when not wanted

help very much appreciated

cheers

 

[CJ_London]

I don't use macro's so just a guess - remove the double quotes around 'done'

 

[murray83]

tried that and i think i may have broke it as its stuck in a loop and now cant open my database ;(

 

[murray83]

fixed it and looked something like this

If [TableName].[FiledName] = done then
Setfield
name [fieldname]
value now()
end if