Thanks for the recommendation. I tried replacing the semi-colon with a dash but it had no affect on the value showing in the combo box.
I attempted to go around this issue by creating a query that combines the two fields before going into the row source. I updated the row source query to pull the fields from the new "combined" query. While the "combined" query shows everything correctly, the combo box is still having the issue of showing only "D2." I also re-incorporated the unique key to ensure that was not causing an issue.
Incorporating the new query updates my row source code to the following:
Code:
SELECT qry_EquipmentCombined.ID, qry_EquipmentCombined.Unit, qry_EquipmentCombined.EquipmentName, qry_EquipmentCombined.EquipmentDetails, qry_EquipmentCombined.EquipCombined FROM qry_EquipmentCombined;
New Row Source Query Details:
Column 1 (0) is ID.
Column 2 (1) is Unit.
Column 3 (2) is EquipmentName.
Column 4 (3) is EquipmentDetails.
Column 5 (4) is EquipCombined.
New Properties:
Column Count: 5
Column Widths: 0";0.5";1";1";0" (Only want user to see three columns)
Bound Column: 4