Populating Userform controls with ListBox selecton

[omagoodness]

Hello again,
I have a form to enter recipes. The ingredients for the recipe come from a table called "tblProducts". I need to be able to edit the recipes in the table so I have a ListBox at the top of the form. (See image below). My problem is this; When I dblClick the item, all fields are populating correctly except the ingredients. I have unhidden columns in the ListBox for trouble shooting purposes. I will only show the name and date. As you can see, the record number is correct and because the ListBox has the information, I assume that the problem lies with the underlying code of the ListBox (show below). FYI, I have code on the form initialization to populate the ComboBoxes for new entries, also included below. I have spent over 8 hours trying to find the problem so I need help.
RecipeForm.png

The code behind the ListBox is:

Please Login or Register  to view this content.

The code on the form initialization to populate the ingredient list boxes is: (it populates them ComboBoxes no problem but I'm not sure it doesn't interfere with populating from the listbox )

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Could we see the workbook? Far easier to diagnose an issue that way.

BSB

[omagoodness]

Since I posted, I comment out the code on form initialization and the form populated fine. Then I added the RowSource to the comboboxes on the form and same thing again, did not populate. The difference between the rowsource for the other comboboxes on the form is that the values come from dynamic lists on Sheet "Lists" whereas the one for the ingredients comes from a named table range.

Here is a copy of the file.

I have another question but it is related to a different subject so will post in a new thread.