I have created a form which allows for the user to search through records which are displayed in a listbox. My question is what do I need to do so that double clicking on a record in the listbox opens up a different form with that record's details?
My listbox has no control source and is set to show 5 columns including the primary key. The form I want to open from this listbox has the same table listed as its record source. How do I go about doing this? Is it a coding matter?