Skip to main content
Question

Create URL to Add Record Based on Field ID

  • December 14, 2018
  • 0 replies
  • 31 views

I am attempting to create a button that will allow the user to add a new record and copy the data in all fields to the new record. 

This code has worked in the past. However, this time it just creates a new record without copying the field data over.

URLRoot() & "db/" & Dbid() & "?a=GenCopyRecord&rid=" & [Record ID#]

I think the fact the record id is not used as the key lookup field may have something to do with it. 
I tried changing [Record ID#] to {EA#] and rid to fid but it did not work. I get a record not found error message. 
Any suggestions to get me on the right track would help. Thanks. 


This topic has been closed for replies.

Is there any chance the fields on the form are set to read only? I have found that affect the behavior. If that does not work I do have a foolproof plan B and plan C.