Dropdown bound field issue

Posted on 2013-12-16
Medium Priority
Last Modified: 2013-12-16
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??
Question by:gogetsome
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 39721806
change the bound column to 2

Author Closing Comment

ID: 39721854
Okay, cool... so it's not zero based. Thank you works great!

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Implementing simple internal controls in the Microsoft Access application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question