Search results

Thanks for pointing that out, I was definitely overthinking this problem and couldn't see the wood for the trees. The simple solution was Eval("[TempVars]![SheetName]"):D

Hi everyone, this it my first post for help, I pride myself on being able to google and read up to solve problems but this one has got me beat. I am in the final stages of building an access database for my company, part of which involves two tables [StaffDetails] and [Holidays]. The junior...