Need to filter query and have subform updatable

Hello All

I am having issues with a subform add-on that I have been working on.  

A few years ago I built a Presenter/Speaker processing database that tracks conference presenters and presentations. On the main form, you select the presenter and all their sessions will be listed giving times, room, and date as well as other things.

On the subform (frmRank), I have  a list of all presenters in the same session based on the Combo_ID (cascading Combos). I am using theDBGuys sort code  to sort the presenters in the order they will present during their session. Selecting the drop down number in the combo box moves the record to the desired position.  This is working well. I have also added Allan Brown's ConcatRelated() code where in the event that 2 presenters are co-presenting the same presentation, they can both be listed in the same field. The check box will assign the current presenter to the one selected in the presenter list .

 I have tried to SELECT DISTINCT in qryRank and combinations of other queries but produces an un-updatable subform and consequently a sort order that no longer works although I can still add records that get updated by the main form.  

I am so close, but not sure of my next approach to produce a form that groups and is updatable . Here is the sql from the query

SELECT tblPresentationMain.Combo_ID, tblTitle.SortOrder, tblTitle.ID, [Last Name] & ", " & [First Name] AS FullName, ConcatRelated("FullName","qryRank","tblTitle.ID = " & [tblTitle.ID]) AS FullName_CC
FROM tblTitle INNER JOIN (tblSPK INNER JOIN tblPresentationMain ON tblSPK.ID = tblPresentationMain.SPK_ID) ON tblTitle.ID = tblPresentationMain.Title_ID
ORDER BY tblPresentationMain.Combo_ID, tblTitle.SortOrder;

Select allOpen in new window

Cheers