2013 Access search ability
I have a database of our inventory that will be shared with technicians and support staff. I already have it set up with permissions, login and such. What I am looking to do is after login, it would go to a form (or a report if that's more appropriate) where the user who is not able to determine the part number can type in any value (a text marking on a part) and the program would return a list of data that contains the value they entered. It would be like the 'Find' function in Access, but more of a 'Find All' function. Any help on this would be much appreciated!
Access 2013 multiple table search
I have a form and subform for search results with multiple tables of inventory. I was wondering if there is a way to link all the tables together(9 of them, all with the same headers in the table) in the control source for the subform so that when a search is done, it will return data from any table that has the matching info in the appropriate field in the search text box