I have a client with a Database that they frequently search by last name (possibly only). Yet it has MANY fields. Problem is they are often forgetting to change to the last name field to perform the search so when they search, they often get back no records because there is no state named "smith".
How can I force Access (2013) to ONLY search the last name field when search is requested?
One solution I tried was to make a dedicated search box on the form itself - in theory this works - except when I type in the criteria and click my search button, it doesn't actually change the record - it's like Access is saying "Ok, I'll search for smith. Ah, found him." and I say, "Great, where's the info?" and access says "Oh, you want me to show you that record? I didn't realize, sorry"
Any help appreciated (I'm not married to any particular method).