Answered: Double Click on listbox record in form, takes you to the recordset in the form.
I am currently working on a form in Access 2013 where I have a query setup in a listbox that shows all assigned customers to a division. When you doubleclick on the listbox value, I want it to take you to that recordset in the form.
Currently, my code looks like
i = List215.Listindex +1
DoCmd.GotoRecord AcDataForm, "Formname", AcGoto, i
The problem is my listbox is a filtered query and when I run the above code, it takes me to a different record. I want to find a way to See what the primary key's value is of the users selection, then search the record set for that value then take you to that record.
The first option does not do what I want it to do. It does open the query, but the action I want to happen is when someone clicks on the listbox's value, It will auto populate the recordset in the form based off the selected item in the listbox
My query's are just filtered based of the different divisions.