Call form as update or insert depending on value in form

[Ubaidullah]

Hi,

I have a memory form where the user enters a code.

On Save, I want to call a Form.

The form should be in Insert mode if the code is not in the table
but in update mode if the code is found in the table.

I set 'URL on Save' to a variable and set the value of this variable in the first embed in the SetFormAction routine.

But this doesn't seem to work as this embed code runs on opening the Memory form and the fields are blank.

So, it seems that action (insert or change) should be set in the called form as the url is formed before any fields values are input.

In the form, Advanced, I can set "Default Form Action". But how can I make it conditional?

Thanks
&
Regards,
Ubaidullah Nubar.