Skip to main content
Question

Create Button to Add New Record but carryover certain fields from existing record

  • September 21, 2017
  • 0 replies
  • 25 views

I am creating a package testing application. Each package type can be tested on multiple types of equipment. For each equipment test I'd like to create a new record.

I'd am trying to create a button that allows the user to save the current record and create a new test without having to retype the basic package information each time.

I've found the following code which will save the current form and create a new record with the same info. I'd like to do the same thing only have certain fields with basic package info save to the new record automatically. So essentially, I am saving the package information but wiping the test results to enter a new test onto a new record.

URLRoot() & "db/" & Dbid() & "?a=GenCopyRecord&rid=" & ToText([Record ID#])
This topic has been closed for replies.

You have already answered 95% of you Question. So the last 5% is simply to go to the field Proprties that you do NOT want copied over and uncheck the box that says to copy these fields when the report is being copied.