Leon,
I agree with the advice given re Option Explicit an Compile.
Here are a couple of links from Mike Wolfe that may help with errors generally:
1 - RunTime Errors
2 -Logic Errors
Moderator
Windows 10 
Office 365
Leon,
I agree with the advice given re Option Explicit an Compile.
Here are a couple of links from Mike Wolfe that may help with errors generally:
1 - RunTime Errors
2 -Logic Errors
Database Tools, Database Documenter, Report Record Source
How to reset AutoNumber in Access 2016 using Database Tools / Compact & Repair Database
Analyse my Database to find unattached Objects
How to analyse data?
Posting Permissions
Reply With Quote