I have a subform that has a recordset that I want another form to open when a record is selected from the subform. What event do I use and in what form to I add the VBA code to for this situation?
The main form that I am selecting records through is my search form called frmInventorySrch. When entries are made in this form certain records are displayed in the subform frmInventory What I want is to be able to bring up another form called frmLayout that uses box controls to represent different areas of the shop where the item can be located and change the color of the box that corresponds to the location of the item in question. My question is what event do I use and in what form do I trigger the event?