Discussions

Expand all | Collapse all

Create URL to Add Record Based on Field ID

  • 1.  Create URL to Add Record Based on Field ID

     
    Posted 12-14-2018 05:12
    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. 




  • 2.  RE: Create URL to Add Record Based on Field ID

    Posted 12-14-2018 14:56
    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.