That query had the "C" bit in the criteria that I thought looked goofy. This appears to work:
SELECT "C" & [Cap_ID] AS PartName, [Capacitors].[Cap_Value] & "Uf " & [Cap_Type] AS PartQ
FROM Capacitors
WHERE ((( [Cap_ID])=[Forms]![Capacitors]![Cap_ID]));