I have built a database with about 12-13 tables. The program is user friendly as I can make it. What I cannot get it to do is I would like from the main form to be able to look up or search entire database (all tables) for information in the user is looking for. I can use the search option on every form that links back to the table but I cannot get it to have one search do all. My question is can I have one command click, search all tables based on the criteria the user enters? Most of the time my users would be entering a number. Any help in solving this would be greatly appreciated.
Thanks
Thanks