I am having this error appear on a form that i have created that has a subform in the Form Footer - the purpose is simple - when you select one of the records above the subform should display the log items for the selected record.
I have done this many times in previous versions of Access but in the latest version (2016) I am getting a 'Error -3004 - There is no message associated with this error' - message.
The main form and the subform both have the necessary linking field i.e. common definition nvchar 50 - the main table has the linking field set as a Primary Key and the subtable has the linking field not set as PK - I have tried it with it set to PK.
I have tried compiling all of the VB code and get no errors. I have tried Compacting and Repair and get no errors.
The error occurs when I try to open up the form with the subform on it. Both forms individually work perfectly - I can open the main form or the subform by themselves and get no errors.
Interestingly this application has several similar forms with subforms in the Form Footer and they all work perfectly well - though these forms were designed in earlier versions of Access.
Completely baffled on this one - anyone else seen this in any version of Access but particularly Access 2016?
Thanks for any help!