Listbox with Select Distinct Record to be Expand on a Field on New Form

[jlcford]

I currently have a listbox with multiple records that are listed as "Select Distinct". I would like to enable a double click event on a particular Distinct record in the listbox and open a second form which displays all the records that are combined in the "Select Distinct" record. To complicate matters these records have a concatenated primary key ( 4 fields equip_init, equip_nbr, repair_dt, repair_order_nbr)

Any help would be greatly appreciated.

Thx,

jlcford

 

[ezfriend]

filter the new form with what's in your list or change the form's control source (sql) so that it filters to just those in your list.