I tried the code several times but can't seem to get it to work.
I tried the code several times but can't seem to get it to work.
Sorry but I can't help, I cannot open the database, saying I need a newer version (I have Access 2013). You must be using some newer features such as attachment or multi-value fields which most developers avoid.
Have you tried to put a break in the code and step through line by line and see what values do you get for the ID and from the dLookups?
Cheers,