I'm by no means an access guru, I ended up being roped into designing a database for a friend.
I've used the dynamically searching multiple fields tutorial posted by John Big Booty on this website, this has worked fine,
The users upgraded from Access 2007 to Access 2010 a few weeks ago (don't...