Hi! I have form that consists of combobox,listbox, and option group. If I select one of the technician from the combobox, listbox will show up the customers for that technician, which is build from a query. If I double click on one of the customers "lastname" field in the list box I want to open a form(Order Details Subform1) for that specific record.
Private Sub List7_DblClick(Cancel As Integer)
DoCmd.OpenForm "Order Details Subform1", acNormal, , "Lastname = Me!List7!Lastname"
With this code I am getting "Order Details Subform1" with nothing.