I have created a database in which the reports are going to be used by 3 different location i.e. Los Angeles, Wichita and Toronto. There is a field in a table [Location] the designates the office branch. Management has requested all branches be able to view the same reports, but should see ONLY their branch information, i.e. when Wichita views their reports it should only contain data for Wichita.
Currently I have created a form for each branch containing reports in an option group and text boxes to pick a data range (code courtesy of Allen Browne's post). I know that I could then create 3 different queries and have the criteria default be each location, then base each branches reports on the appropriate query, but to me this doesn't seem like the most efficient solution. A prompt isn't an option, as a user in Toronto could easily enter Wichita or vice versa. Also, I would like the user to have the option of using a date range for each report.
I am somewhat familiar with VBA and have used it in databases before (customizing examples posted on forums) , but I am not a programmer. Any suggestions on the best way to tackle this issue would be greatly appreciated!