Create URL to Add Record Based on Field ID

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
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. 

Photo of Traci S

Traci S

  • 280 Points 250 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
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.