I have a database that I am creating in Access 2000. I have 1 Main table and 5 different forms that provide data to this “Main” table. Lets say the tables are BackOffice, AcctsPayable, Assets, DollarLoss, and FeeLoss. Also, within the Main table, I have a field called “FormType” and that is where for each record, depending on the form chose, will put that form name in that field. I have made each form off of a query from the Main table to only pull records for whatever table they are in at the time. I want to put in a search feature to search the records for when they need to go back and update one. However, it seems as if I can only attach it to one form. So, if I search an ID that I know should be in Assets, it will bring it up in BackOffice (because I had it attached to that form and could not figure out how to get to pull up the form they wanted to look at). Is there a way to fix this so it would have shown up in the Assets form or any one they are trying to find?
In other words, how do I get my search function to, no matter which ID they are looking for, pull up the correct form that is attached to that ID number?
Do I make any sense? Hope so!
Thanks,
Melissa
In other words, how do I get my search function to, no matter which ID they are looking for, pull up the correct form that is attached to that ID number?
Do I make any sense? Hope so!
Thanks,
Melissa
