Forum Discussion
EstherGrandal_D
8 years agoQrew Cadet
Try this formula;
URLRoot() & "db/" & Dbid() & "?a=er&dfid=1&rid=" & ToText([Record ID#])
& "&nexturl=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&dfid=1&rid=" & ToText([Record ID#]))
This will edit using form ID #1 and then redisplay after Save on that same form. You need a bottom for each form and they need to press the right bottom
You can also set up a new numeric field like "form number depending of the user " related to the user and use it in the formula , in this way it pops automatically one different form for each user.
Do you want to leave them in Edit mode after saving? if so, then in that last line of code, change the "dr" (Display Record) to "er" (Edit Record).
I hope it helps.
URLRoot() & "db/" & Dbid() & "?a=er&dfid=1&rid=" & ToText([Record ID#])
& "&nexturl=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&dfid=1&rid=" & ToText([Record ID#]))
This will edit using form ID #1 and then redisplay after Save on that same form. You need a bottom for each form and they need to press the right bottom
You can also set up a new numeric field like "form number depending of the user " related to the user and use it in the formula , in this way it pops automatically one different form for each user.
Do you want to leave them in Edit mode after saving? if so, then in that last line of code, change the "dr" (Display Record) to "er" (Edit Record).
I hope it helps.