I am a beginner with Access. On a form and in a control called "location" I enter a street address. In the next control I enter a repair type (e.g. water heater, faucet, etc.). In the next control I enter the date. The following month I might go back to the same address and do a different repair. When this occurs I duplicate the first record for this address and change the repair type and date. I now have multiple records for this address. On this same form I have added a combobox which is set up as a find box. When I drop the list down I can see the multiple records for this address along with all the other addresses I have worked at. Rather than seeing the multiple records this way, I would like to have a combobox where I could choose a specific address and then click a command button that would pull up a list of repairs for only the address chosen in the combobox, kind of like a "filter by selection" in a table where you get a clean list of only the records of a specific selected value in a field. Is this possible?
-
-
Hi Frank,
You can do this using a technique called cascading combo boxes. Check out this handy tutorial for instructions on how to set it up.
You may end up needing to extend this to the repair type and date text boxes depending on how you have your form setup.
Hope this helps,
beacon -
This is a very commonly asked question (in its various forms).
In this case, I'd draw your attention first to the design of the database. Commonly repeated items, such as the address, should probably be stored in their own dedicated table, and links to these records included within each job. See Database Normalisation and Table structures for more on this.
As for the question itself, we have an article on that here on the site - Cascaded Form Filtering - which includes an example database that you can experiment with.Comment
Comment