Thanks @kuovonne
Much appreciate your reply!
I must admit, I thought there was a way of pre-filling the form by passing a recordID through the URL (of a record from the same table which has the values you want to pre-fill) . I’m sure I saw one of @Gareth_Pronovost excellent videos describing how to do that. But I can’t find the video now and couldn’t get that to work anyway!
You can prefill a linked record field by passing the record id of the record to link, instead of the primary field value. You can get the record ID of a record using the formula RECORD_ID(). However, I recommend limiting this to only internal forms. If you use this technique in an externally facing form, you risk exposing all the the other records in your table to the public.