Upload new image or copy

[Diarmuid_O_Brie]

I have an image column in my table, which works well to upload and then view pictures. However, to avoid users repeatedly taking a photo of the same ‘defect’ I have inserted a column of type ‘text’ with the option of selecting between ‘adding new photo’, ‘use the one from the previous record’, or ‘no photo’ [albeit in fewer words!!]. Adding this button is easy, and I can also conditionally show the image object only if the aforementioned selection = ‘Upload new photo’.
However, where I’m stuck is what my expression needs to be to cater for the 2nd option [copy from previous]. I added an if statement in the formula box for the image column, around retrieving the image path from the previous record if user selects ‘copy from previous record’, but I don’t know what my else statement needs to be to cater for the option of uploading a new photo, so my image object just disappeared off my screen. What to do …!
many thanks for any ideas of where I’m going wrong