Dropdown bound field issue

Hello, I have a dropdown that is populate with this:

rowsource: SELECT [ScrapCodes].[ScapCode],[ScrapCodes].[Reason] FROM [ScrapCodes];
bound column: 1

When the record is saved the value saved is ScrapCode, but should be Reason.

How can I fix this??
gogetsomeAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
change the bound column to 2
0
 
gogetsomeAuthor Commented:
Okay, cool... so it's not zero based. Thank you works great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.