I am currently doing a Find on Records for a specific location by user, I am using a single variable, however if they pressed show all records, it would show records from all location,
Is there a script trigger that fixes this
Not a Script Trigger per se, but you can substitute a script of your choosing in Custom Menus for the Show All Records command.
If you're needing other locations' records to be restricted from the user, you should set this in the privilege set. Here's an excellent video on the topic; DevCon 2015: Security, Inside and Out - Ronnie Rios
Like Mike says, though, you can take over the show all menu item with a custom menu, too. We do something like that because of the "active" flag we have in most tables. Since normally the user really means "show all active records", that's the default and we made a separate menu item for showing all including inactives. Works fine, but remember not to rely on this as a security tool.
Since the OP didn't specify it was security-related, I didn't mention the priv set angle. (Thought about it.) However, even in that case, it's still beneficial to hijack the "Show All" command to prevent the dreaded "<No Access>" markers from showing up all over the place.
Thanks for your help, Mike I think I will try your tactic for now
Get ( FoundCount ) = Get ( TotalRecordCount ) could be your "trigger"
Retrieving data ...