I had two tables in a database, one called "HDD", which holds information on hard disk drives, such as serial number, model number, capapcity, etc. I had another table I called "External", which I use to keep track of information regarding external disk drive enclosures I use for backing up systems. That External database also has a "Drive SN" field that has the serial number for the hard disk drive within the enclosure. I created forms with matching names for each table, i.e. an "HDD" and "External" form.
I wanted to be able to double-click on the drive serial number in the "External" form and have the "HDD" form open with the record displayed with the corresponding serial number, so that I could view all of the information on the particular hard disk drive within the drive enclosure that I had selected in the "External" form. I used the following procedure to be able to do so.
- In the drive serial number field of the "external" form, I right-clicked and chose Properties.
- Scrolled down to the "On Dbl Click" field.
- I clicked on the button with "..." on it.
- I chose Macro Builder and clicked on OK.
- I gave it a name of OpenHDD and clicked on OK.
- For Action, I chose OpenForm.
- In the Form Name field, I put in HDD, the name of the form that displays information on the hard disk drives.
- For View, I selected Form.
- For Where Condition, I clicked on the "..." button and chose Tables then the HDD table beneath it.
- I then selected Serial Number in the next column and
double-clicked on <Value> in the last column, which gave me
[HDD]![Serial Number]in the Expression Builder field. - I then clicked on the equal button to add
=at the end of the expression and then added Forms![External]![Serial Number] giving me[HDD]![Serial Number] = Forms![External]![Drive SN]. - I then clicked on OK
- For the Comment field, which is to the right of the Action field, I put "Open HDD form to drive corresponding to External drive SN"
- I then closed the Expression Builder window, saving the macro.
- I then closed the Properties window that was open for the Drive SN field.
I was then able to click on the drive serial number field in the External form and have the HDD form open displaying the information on the hard disk drive within the enclosure.
