Hello,
I have a piece of code (below) which is not working in QuerySave. If Status=Approved and Change = Yes then I want a message box to appear, the user clicks OK then it stops saving, it goes back to the document for them to do something else… The message box is appearing fine, but it’s not stopping there, it continues to save the document.
I need this to be in QuerySave or an event, and not an action button.
I need it to stop saving.
Any ideas where I am going wrong?
If (source.FieldGetText( “Status” ) = “Approved” And source.FieldGetText( “Change” ) = “Yes”) Then
Messagebox "Please press the Notify Change Button to confirm your change, your expense requires re-approval by your line manager."
source.GotoField( "Name" )
continue = False
End If
Thanks,
Hayley.