Can't find any way to declare variables in the sort of module that Access uses by default.
Having changed the default, I now get 'Option Compare Database' as the first line (previously nothing was there). Adding anything at all in that section, or changing it to 'Option Explicit' has the...