Need a button to view current record in a different form

Question

*Edited*I am looking to create a button on the main form that when clicked will Save the current record form and then show the info in that current record in a different form? I have tried the auto save when navigating away function. It doesn't establish the Record ID# so the formula showing the current form also shows in the newly opened form.------------------------------Chris Swirtz------------------------------

markshnier__you · Answer

np, look at your list of forms and observe the Form ID#.
Then make a Formula URL button like

URLRoot() & "db/" & dbid() & "?a=dr&dfid=10&rid=" & [Record ID#]

That says to display the record on Form ID #10

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

chrisswirtz · Answer

Perfect, thanks! I knew it was something like this, just couldn't quite get it right.------------------------------Chris Swirtz------------------------------

chrisswirtz · Answer

Mark,Would it be possible to add the save function to this formula? Like so when the user clicks the button, it saves the record as is before opening the new form?------------------------------Chris Swirtz------------------------------

markshnier__you · Answer

If the table is set in properties to auto save then when you push the button and it should save the record before we displaying it.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

chrisswirtz · Answer

Hey Mark,I turned on the auto save as you said and have the button that takes the user to a different form set to open in the same window so it has to navigate away from the current form/screen. When I click on said button it does ask me to save the record first, which is what I want, but when it opens the subsequent form, it is in 'add new" mode instead editing the the new form with the same Record ID and info I just navigated from. It's like the save action doesn't allow for the button formula to pick up the newly created Record ID.&nbsp;That being said, when I say hit "save &amp; keep working", then hit the button, it works just fine. Which is why I wondered if I could incorporate the "save &amp; keep working" function into the button formula.------------------------------Chris Swirtz------------------------------

Forum Discussion

Need a button to view current record in a different form