I found a search form online (I think on one of these FAQs) that you can click a command button on an entry form and open up. You have the fields available for search on the top, and you can enter criteria for one or more of those. Then there is a bottom half, which is a 2nd form that shows up with results.
You can cycle through the results and pick the one you want. Choosing it will close the search form and jump the entry form to tha chosen record.
The challenge that I have here is that I have an entry form with 5 sub forms. Within those subforms, there are multiple command boxes that open further forms to enter more information. This is a completely normalized database. I need to be able to search all records in my database and bring up the results no matter where they exist. How can I do this please? I basically have almost 200 fields and this is too much to put on one search form. Beyond taking forever to build, I can't fit that many on one form.
Any thoughts as to how to accomplish this, please?
Thanks!
You can cycle through the results and pick the one you want. Choosing it will close the search form and jump the entry form to tha chosen record.
The challenge that I have here is that I have an entry form with 5 sub forms. Within those subforms, there are multiple command boxes that open further forms to enter more information. This is a completely normalized database. I need to be able to search all records in my database and bring up the results no matter where they exist. How can I do this please? I basically have almost 200 fields and this is too much to put on one search form. Beyond taking forever to build, I can't fit that many on one form.
Any thoughts as to how to accomplish this, please?
Thanks!
