I'm trying to import a list of employee details from Excel into Access. I seem to have hit a bit of a problem. I've cleaned the data and spent time optimising. However I have a 'list' created by 'data Validation' of locations where people are based in excel.
In the event that I open the dbase and userform surprisingly and click on the appear/conceal order catches I get the bland "the expression On Click you entered as the occasion