Hi guys thanks for your input,
don't think WGM Dmax will work as we are looking for a file name outside of access, stand to be corrected though....
Orange, yes only x 1 image per date definitely if that helps to find the correct method
Just though though, am i better having a temp table perhaps tblImageDate, when the image is generated add the name of the image file that has got the date formatted as: field1 (FileName) orange 04-06-22.jpg stored from initial image, perhaps another text field Status and auto have Rename in that field ?
Then when we tick the check box for collection (collectedDate) is then updated for all items on the image
Then will WGM option of DMax or DLookup File Name and do query Update to collected date
Call the file to match orange 04-06-22
Name As FileName From Table
Delete that record in the images table ?
Again guys if i am barking up the wrong tree then apologies