Problem with Listbox update via Combobox and Field Values

[wubbit]

I have a listbox(includesA) which works via combobox(sel_mac) update sort and the field values that were selected prior, however, the values it posts are numeric ID values and not the actual field values I want to be shown in the listbox.
Any ideas on how to fix this problem? I have some code below that pushes the updates from the combo to the list.

Private Sub sel_mac_Change()
Dim strSQL As String
strSQL = "SELECT Includes.macro_number, Includes.macro_part1, Includes.ID, Includes.catagory FROM Includes WHERE (((Includes.catagory)=" & Forms!Proposals!sel_mac & "))"


Me!includesA.RowSourceType = "Table/Query"
Me!includesA.RowSource = strSQL
Me!includesA.Requery

End Sub

I have included a snapshot of the problem area.

[June7]

Why do half of the lines show the descriptive info instead of ID numbers? Do you want to provide the project for analysis? Follow instructions at bottom of my post.

[wubbit]

The lines that show the info are the populated ones from the combobox, the others I think are pulled from the macro_combobox that is in the table. It is a lookup field that holds the values of includes.id - at least that is what I can see... not sure what is wrong there. I will add the database though. thanks.

[wubbit]

Here is the database.

[June7]

The tables are web-based (Sharepoint?) and I can't open in Design view. Makes it hard for me to analyse structure. Can't even open the Relationships builder.

I tested the listbox rowsource SQL in an independent query and find it does not show the additional rows with the IDs and checked boxes. So I am baffled about where those rows are coming from. The query doesn't show the checkboxes so somehow this issue is tied to the checkboxes in the listbox.

I do find it odd that the rows in listbox with checks are the problem items. How are those checkboxes made to show in the listbox? I have never seen this before. But then I have never worked with a web database.

[wubbit]

The listbox is bound to the macros field, which hold the includes.id (which is the listbox data key). I was under the impression that using the macros field as a bound item would cause the list to populate the checked boxes for those items selected previously. I am not sure what happen with it, but this is a key error that is causing some issue.
I can try to figure out why you are not able to open the design view, I have not packaged it in anyway and it allows my machines to edit the database.

Let me see if someone has locked the database, I am working with a few people on this for testing purposes.

[June7]

The macros field is a multi-value. I refuse to use multi-value fields because of the issues they cause.

[wubbit]

It was the only way I could get the multiple selections to work with little issues. I can pursued the client to accept the redundant listings I believe.

Thanks for the assistance.