TraciSchefdore
7 years agoQrew Trainee
Create URL to Add Record Based on Field ID
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 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.