Im new to access.
I have a form that has a column with a row source of
SELECT [SpecimenTable].[ID], [SpecimenTable].[SpecType] FROM SpecimenTable ORDER BY [ID];
and that works great. It pulls the information and displaces the "spectype" as the choice. When I put that into a form with the same row source, it shows be the ID, not the SpecType as the option.
A work around I have found is deleting the first part and just having
SELECT [SpecimenTable].[SpecType] FROM SpecimenTable ORDER BY [ID];
but then it wont let me actually click on anything. Any advice?