I am attempting to create a form (shown below) which will enable you to enter details about a new assessment, however the (Autonumber) ID for this is not populating. I have seen in some threads it should do this when data is entered into other fields, however when I attempt this, nothing happens - except for a message in the bottom left-hand corner which says "Cannot Add record(s); join key of table 'Assessment Details is not in recordset' (Assessment Details is the table I am trying to input information into, an image of the error is shown below the form) this appears to be a paradox and I can't work out how to fix it, your help is much appreciated!
Unfortunately I am unable to post the database on here due to the nature of the information held, Also, I would appreciate it if any advice you give described how to complete the task in Macro form since I do not currently understand either of the other options.
Thanks in advance!