Hmm, I'll look at that change as well this weekend.
Currently the username is just a standard module called modUser .
Yes the macro is just an option on the table in design view. This is the first time I've ever used a macro on the table itself.
Point of note, moving the lookup field appears to have reduced the frequency of the error but it still occurring daily.